1.应用
1)从一个表选取数据,插入到另一个表中
SELECT *
INTO Persons_backup [IN DBname]
FROM Persons
- 将数据写入文件
SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM test_table;
2.区别
Insert into Table2(field1,field2,...) select value1,value2,... from Table1
1)Table2必须存在
2)不要加values
,和普通insert into
不同,可以理解为将values
换成了select
参考:
https://blog.csdn.net/insis_mo/article/details/84936753
https://www.cnblogs.com/hetaoyuan/p/12520804.html
https://dev.mysql.com/doc/refman/8.0/en/select-into.html