MYSQL SELECT...INTO 遇到的问题

mysql> SELECT NAME,SCORE INTO PEOPLE_BACKUP FROM PEOPLE;

ERROR 1327 (42000): Undeclared variable: PEOPLE_BACKUP

原文语句:

SELECT *
INTO new_table_name [IN externaldatabase] 
FROM old_tablename

解决方法:MYSQL中不允许使用SELECT..... INTO....语法，需改成INSERT INTO NEW_TABLE SELECT....FROM OLDTABLE;

实例:

mysql> INSERT INTO PEOPLE_BACKUP SELECT * FROM PEOPLE;

Query OK, 5 rows affected (0.04 sec)

注意事项(自提):

        1.新表必须提前创建

        2.不一定整个数据列，可以选择部分数据列