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.不一定整个数据列,可以选择部分数据列