Introduction to PHP MySQL (database related knowledge)

ThroughPHP, you can connect and operate the database.

MySQLis 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.

What is MySQL?

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 compiles on some platforms.

MySQL is free to download and use.

MySQL is developed, published and supported by Oracle Corporation.

MySQL is named after the company founder Monty Widenius's daughter: My.

Data in MySQL is stored in tables.Tableis a collection of related data, which contains columns and rows.

Databases are very useful when storing information in categories. A company's database might have the following tables:

Employees

Products

Customers

Orders

PHP MySQL

PHP combined with MySQL is cross-platform. (You can develop on Windows and apply on Unix platforms.)

Query

A query is a query or request.

Through MySQL, we can query the database for specific information and get the returned record set.

Please see the following query (using standard SQL):

mysql> set names utf8;mysql> SELECT name FROM websites;+---------------+| name |+---------------+| Google || 淘宝 || php中文网 || 微博 || 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.

This article explains the relevant knowledge of the database MySQL. For more learning materials, please pay attention to the php Chinese website.

Related recommendations:

PHP MySQL operation and method of reading data

PHP method of sending email

Understanding and using PHP Cookie related knowledge

The above is the detailed content of Introduction to PHP MySQL (database related knowledge). For more information, please follow other related articles on the PHP Chinese website!