INSERT INTO
TbaleName
(字段名)
SELECT (字段名) FROM TbaleName WHERE 1=1 AND -----------------
注意A表与B表之间表字段名对其,结构相同。
INSERT INTO
TbaleName
(字段名)
SELECT (字段名) FROM TbaleName WHERE 1=1 AND -----------------
注意A表与B表之间表字段名对其,结构相同。
转载于:https://www.cnblogs.com/DeBugger-/p/10038199.html