What is the difference between “insert” and “insert into” in SQL statements?

In SQL statements, both INSERT and INSERT INTO are used to insert new rows/records into a database. The difference between them is as follows:

1. Difference in grammar:
2. The INTO keyword can be omitted in the INSERT statement, and you can directly use INSERT. For example, INSERT INTO table_name (column1, column2, …) VALUES (value1, value2, …) can be written as INSERT table_name (column1, column2, …) VALUES (value1, value2, …).
3. The INSERT INTO statement must include the keyword INTO and cannot be omitted.
4. The INSERT INTO statement allows you to specify the column names for inserting data, or you can omit the column names and the values will be matched to the table columns in order. For example: INSERT INTO table_name (column1, column2, …) VALUES (value1, value2, …).

   If the INSERT statement does not specify column names, the values will be inserted into the table based on the column order. For example: INSERT table_name VALUES (value1, value2, …).

In general, INSERT and INSERT INTO have similar functions, with slight differences in syntax. Generally, it is recommended to use the INSERT INTO statement as it is more clear and easier to read.