将一个表格的某些列复制到另一个表格中
方法1:
SELECT * INTO newTable
FROM (SELECT column_name(s) FROM oldTable) AS f
从oldTable中选取一些列column_name(s)复制到newTable中
方法2:
CREATE newtable
SELECT column_name(s) FROM oldtable
参考:
将一个表格的某些列复制到另一个表格中
方法1:
SELECT * INTO newTable
FROM (SELECT column_name(s) FROM oldTable) AS f
从oldTable中选取一些列column_name(s)复制到newTable中
方法2:
CREATE newtable
SELECT column_name(s) FROM oldtable
参考: