在MySQL中,SELECT INTO和INSERT INTO是兩個不同的操作。
SELECT column1, column2
INTO new_table
FROM old_table
WHERE condition;
例子:
SELECT first_name, last_name
INTO new_employee_table
FROM employee
WHERE department = 'IT';
INSERT INTO table_name (column1, column2)
VALUES (value1, value2);
例子:
INSERT INTO employee (first_name, last_name)
VALUES ('John', 'Doe');
請注意,SELECT INTO和INSERT INTO的使用方式和語法不同,需要根據具體的需求選擇合適的操作。