0
MySQL
MySQL is a Relational Database Management System. It was first released in 1995 and is most commonly used with the PHP programming language. MySQL is open source and 100% free to use.
526 Questions
A database query is a piece of code (a query) that is sent to a database in order to get information back from the database. It is used as the way of retriving the information from database
A database "query" is basically a "question" that you ask the database. The results of the query is the information that is returned by the database management system. Queries are usually constructed using SQL (structured query language) which resembles a high-level programming language.
The term 'query' means to search, to question, or to find. When you query a database, your searching for information in the database. Different query languages exist for different type of databases. MS Access uses SQL, which stands for Structured Query Language. MS Access contains Tables, Forms, and Queries. The Forms are used to enter or display the data, the Tables are where the data is saved, and the queries are used to search for specific data.
An example of an query can be this:
SELECT DISTINCT Agent FROM QAMonitoring ORDER BY Agent;
The query searches the 'Agent' field from the QAMonitoring table and sorts the list by last name. There are plenty of MS Access DB forums on the net for more info and help.
Creating a Simple Query in Microsoft AccessHave you ever wanted to combine information from multiple tables in your database in an efficient manner? Microsoft Access offers a powerful query function with an easy-to-learn interface that makes it a snap to extract exactly the information you need from your database. In this tutorial we'll explore the creation of a simple query.
In this example, as with all of our Access tutorials, we will use Access 2000 and the Northwind sample database included on the installation CD-ROM. If you're using an earlier version of Access, you may find that some of the menu choices and wizard screens are slightly different. However, the same basic principles apply to all versions of Access (as well as most database systems).
Let's explore the process step-by-step. Our goal in this tutorial is to create a query listing the names of all of our company's products, current inventory levels and the name and phone number of each product's supplier.
1. Open your database. If you haven't already installed the Northwind sample database, these instructions will assist you. Otherwise, go to the File tab, select Open and locate the Northwind database on your computer.
2. Select the queries tab. This will bring up a listing of the existing queries that Microsoft included in the sample database along with two options to create new queries.
3. Double-click on "create query by using wizard". The query wizard simplifies the creation of new queries. We'll use it in this tutorial to introduce the concept of query creation. In later tutorials we'll examine the Design view which facilitates the creation of more sophisticated queries.
A rowlock is the same--no matter what the database. SQLServer, Oracle, Informix, Tandem, etc. A database's management system, along with the Database Administrator, is responsible for "data integrity". Here's the scenario for a rowlock: Susan is responsible for updating the "sales" table for the day's previous sales activity. Since there are not many updates, she sometimes does the inserts/updates during core business hours. One of the current rows in the "sales" table needs the data updated. The database puts a "rowlock" on this row in this table until the update is committed. If Gina is doing a query (read only) on the "sales" table at the same time Susan is updating it, the row that is being updated is "locked" and Gina will see the "before image" of the row. Once Susan commits the update the row is no longer locked and, if Gina runs her query again, she will see the update.
What is Existence dependency in data base management?
If the existence of entity X depends on the existence of entity Y, then X is said to be existence dependent on Y.
What are the triggers in dbms?
Trigger is defined as a procedural code that is automatically executed in response of certain events on a particular table or view. It is used to maintain the database integrity.
Example: when a new record is added to the student table, new record should also be created in the tables of the attendance, leave & marks table.
What was Tyndale's view of Scripture?
Willaim Tyndale (1494-1536) believed that the common people should have the Bible in their own language so they could read and understand and then follow it. Having studied both Greek and Hebrew at Oxford he was certainly qualified for this great work. His attitude, in being critical of the ignorance of the church of his time, who believed that only the clergy were entitled to read and interpret scripture, can be summed up in a statement he made to a clergyman of the time. "If God spare my life, ere many years, I will cause a boy that driveth the plough to know more of the Scripture than thou dost."
He thus believed the Bible to be the very word of God, and that it could be understood and should be given to the masses.
Are there any MLB stadiums named after a person?
Turner Field (Atlanta Braves), Wrigley Field (Chicago Cubs), Jacobs Field (Cleveland Indians), Busch Stadium (St. Louis Cardinals), and Kauffmann Stadium (Kansas City Royals) are all named after owners of the team. Shea Stadium (New York Mets) is named after the man credited with bringing National League Baseball back to New York. The Twins' home ballpark's full name isthe Hubert H. Humphrey Metrodome. The Washington Nationals used to play in RFK Stadiumwhich is named after Robert F. Kennedy.
How the primary key is declared in MySQL?
Its best to choose an ID for each table to use as the Primary Key (PK). This is best as an INT due to speed.
How to upload excel sheet data into a MySQL database using JSP and Servlets?
It is very easy to upload excel spreadsheet data into a MySQL database using JSP and servlets. Within Java there is a tool where you can designate the name and location of the file you would like to import. Once you furnish the file name Java server pages will do the work for you.
Nested macro calls refer to the macro calls within the macros. A macros is available within other macro definitions also. In the scenario when a macro call occurs, which contains another macro call, the macro processor generates the nested macro definition as text and places it on the input stack. The definition of the macro is then scanned and the macro processor complies it.
How do you draw entity relatoin in databases?
If the question is for databases, then the answer is in the link. If you want to store the ERDs in a database, then the question needs to be clarified to which database.
Does MySQL run on both Unix and Windows?
Yes. There are versions of MySQL for most Unix products, including Mac OS X, as well as Linux and Windows.
How can you restrict the values of data entered into a database?
By creating Data validation rules you should be able to restrict the values of data entered
Can a program be made of only one type of control structure?
Yes, a program can be made using only one type of control structure, such as only using if statements for control flow. However, this may limit the program's functionality and readability, as different types of control structures are often needed to handle various situations and logic.
It depends on the application; most of the time you will find it in the server database.
How do you put today's date into MySQL database?
Use: $todaysdate = date("d/m/y"); And then just send that to the MySQL database
How do you post the data from an input type checkbox in a form to MySQL tables using PHP?
using the post command.$_POST['checkboxname'];
What is the latest version of finacle?
Finacle 10.2...released previous month..now the 10.3 will be released
Can you check symbols like star dot in MySQL database using PHP?
It is unclear what you are asking. If you want to know if you can simulate the regex ".*" behavior in MySQL, you can do so by using LIKE instead of = on the text field and using the percent sign "%" to essentially mean the same thing as .*. Something such as SELECT * FROM user WHERE username LIKE "%eri%"; would select erik, eric, erin, derik and others
What are the disadvantages of databases?
Disadvantages of databases are:
* They are overcomplicated for storage of simple and/or small data.
* They are more complex
* They are more difficult to set up initially
* Crash without saving
traditional file based approach
