Insert into Table2(a, c, d) select a,c,5 from Table1 转载于:https://www.cnblogs.com/cat-dalianmao/p/7464042.html