What is MySQL?
MySQL is a database.
The data stored in MySQL is called a table as a database object.
A table is a collection-related data input, which consists of columns and rows.
Database is useful when storing information, flatly. A company may have a database with the following forms: "employee", "product", "customer" and "order ".
--------------------------------------------------------------------------------
Database Table
A database usually contains one or more tables. Each table is a specific name (such as "customer" or "order "). A table contains records (rows) of data.
The following is an example of the so-called "person ":
City
Henman OLA Timoteivn 10 sandes
Svendson tofu Borgvn 23 sandes
Peterson Calgary Storgt 20 stavangge
The preceding table contains three records (each person) and four columns (last name, name, address, and city ).
--------------------------------------------------------------------------------
Query
Query is a problem or requirement.
With MySQL, We can query the specific information of the database and return records.
Take a look at the following query:
Select the person with the last name
Query the "last name" column of all data in the preceding selection from the "persons" table, a record is returned as follows:
Last name
Hansen
Svendson
Peterson
--------------------------------------------------------------------------------
Download MySQL database
If you don't have a MySQL database for a PHP server, you can download MySQL for free browse: http://www.mysql.com/downloads/index.html
--------------------------------------------------------------------------------
Fact MySQL database
One great thing about MySQL is that it can be reduced to support embedded database applications. Probably because of this reputation, many people think that MySQL can only process small and medium systems.
The truth is that MySQL is actually a standard database website that supports a large amount of data and end users (such as Friendster, Yahoo, Google ).
Let's take a look at the overview of http://www.mysql.com/customers/. the company uses mysql.
--------------------------------------------------------------------------------