SQL不是很好,今天找了个SQL记录一下
insert into table1 (field1,field2) select 'myvalue',field2 from table2
转载于:https://www.cnblogs.com/shootero/archive/2007/08/17/859845.html
转载于:https://www.cnblogs.com/shootero/archive/2007/08/17/859845.html