By using select you create a set with columns and rows, and by design these rows can be insert ed into another table with an equal amount of columns. You can ... ... <看更多>

You need to remove the values clause and just put the select straight after the table and column names of the insert clause: INSERT INTO ... ... <看更多>

INSERT INTO orders SELECT * FROM new_orders;. Insert a single row into the cities table: INSERT INTO cities VALUES (1, 'San Francisco');. Insert multiple ... ... <看更多>