INSERT INTO t2(t2.f1,t2.f2, ) SELECT (t1.f1, t1.f2,) FROM t1 转载于:https://www.cnblogs.com/JoeDZ/archive/2008/07/20/1247042.html