How to write SQL add statement

Use the INSERT INTO statement in SQL to add a new record to the table. The syntax is: INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...), where table_name is the table name, column1, column2 are the column names, and value1, value2 are the values ​​of the corresponding columns. If the column name is not specified, the values ​​are inserted in the order of table definition.

SQL Add statement

In SQL, you can use the INSERT INTO statement to add new records to the table. The syntax is as follows:

 <code>INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...)</code>

in:

• table_name is the table name to which you want to add a new record.
• column1 , column2 , ... are the column names to which the value is to be specified.
• value1 , value2 , ... are the values ​​to be inserted into the corresponding column.

Example

Suppose there is a table called customers that has the following columns:

• id (primary key)
• name
• email

To add a new record to the customers table, you can use the following statement:

 <code>INSERT INTO customers (name, email) VALUES ('John Doe', 'john.doe@example.com')</code>

After executing this statement, a new record will be added to the customers table with name "John Doe" and email will be "john.doe@example.com".

Things to note

• If no column name is specified, the INSERT statement inserts values ​​into the column in the order in which the table is defined.
• An error is raised if the type of the inserted value does not match the type of the column.
• If the value you are inserting contains special characters (such as quotes or backslashes), it must be escaped with escape characters.

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