Through PHP, you can connect and operate databases.
MySQL is the most popular open source database system used with PHP.
If you want to learn more MySQL knowledge, you can check out the MySQL tutorial on this site.
MySQL is a database system used on the Web.
MySQL is a database system that runs on a server.
MySQL is ideal for both small and large applications.
MySQL is very fast, reliable, and easy to use.
MySQL supports standard SQL.
MySQL is compiled on some platforms.
MySQL is free to download and use.
MySQL is developed, published and supported by Oracle Corporation.
MySQL is named after company founder Monty Widenius's daughter: My.
Data in MySQL is stored in tables. A table is a collection of related data, consisting of columns and rows.
Databases are very useful when it comes to storing information in categories. A company's database might have the following tables:
Employees
Products
Customers
Orders
The combination of PHP and MySQL is cross-platform. (You can develop on Windows and apply on Unix platforms.)
A query is an inquiry or request.
Through MySQL, we can query the database for specific information and get the returned record set.
Take a look at the query below (using standard SQL):
mysql> set names utf8;mysql> SELECT name FROM websites;+---------------+| name |+---------------+ | Google || Taobao || Coder Tutorial || Weibo || Facebook || stackoverflow |+---------------+6 rows in set (0.00 sec)
The statement set names utf8; is used to set the database encoding so that Chinese can be displayed normally.
The above query selects all the data in the "name" column in the "websites" table.
To learn more about SQL, visit our SQL tutorials.
If your PHP server does not have a MySQL database, you can download MySQL for free here: http://www.mysql.com.
One of the cool features about MySQL is that it can be scaled down to support embedded database applications. Perhaps because of this, many people think that MySQL can only handle small and medium-sized systems.
In fact, MySQL is the de facto standard database for websites that support huge amounts of data and traffic (such as Friendster, Yahoo, and Google).
This address provides an overview of companies using MySQL: http://www.mysql.com/customers/.