How to insert data command line statement in mysql

How to use the MySQL command line to insert data

In MySQL, you can use the following INSERT statement to insert data into the database:

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

Where:

• table_name is the name of the table into which data is to be inserted.
• column1, column2, ... are the column names into which values ​​are to be inserted.
• value1, value2, ... are the values ​​to be inserted.

Example

Suppose there is a table named "customers" with the following columns:

• id(integer, Primary key)
• name (string)
• age (integer)

To insert a child named "John Doe" with an age of 30 into this table For customers, you can use the following command:

<code>INSERT INTO customers (name, age) VALUES ('John Doe', 30);</code>

Other considerations

• Make sure that the inserted value matches the data type of the column.
• For string values, use single or double quotes to surround the value.
• For date and time values, use the appropriate format (for example, for dates, use the 'YYYY-MM-DD' format).
• You can use the VALUES clause to insert multiple rows at once.
• You can use the ON DUPLICATE KEY UPDATE clause to update an existing row when the insert fails.

The above is the detailed content of How to insert data command line statement in mysql. For more information, please follow other related articles on the PHP Chinese website!