How to enter mysql

Use the INSERT INTO SQL statement in the MySQL table to insert data. You can insert data into the data table through the mysql> command prompt window, or insert data through a PHP script.

The following is the common INSERT INTO SQL syntax for inserting data into a MySQL data table:

INSERT INTO table_name ( field1, field2,...fieldN )
VALUES   
( value1, value2,...valueN );

If the data is character type, single quotes must be used Or double quotes, such as: "value".

Recommended tutorial: MySQL video tutorial

The above is the detailed content of How to enter mysql. For more information, please follow other related articles on the PHP Chinese website!