insert into 语法

Sure, here is the basic syntax for the SQL INSERT INTO statement:

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

- `table_name` is the name of the table where you want to insert data.
- `(column1, column2, column3, ...)` specifies the columns in the table where you want to insert data.
- `VALUES (value1, value2, value3, ...)` specifies the values to be inserted into the columns.

For example, if you have a table called "employees" with columns "id", "name", and "salary", you can insert data using the following SQL statement:

INSERT INTO employees (id, name, salary)
VALUES (1, 'John Smith', 50000);

This would insert a new row into the "employees" table with an id of 1, a name of "John Smith", and a salary of 50000.