insert into tablename (a1,b1,c1) select a1,b1,c1 from tablename2 where ………………
没有tablename2 只有tablename 怎么办!
insert into tablename (a1,b1,c1) select a1,b1,c1 union select a1,b1,c1 union select a1,b1,c1 union select a1,b1,c1 union select a1,b1,c1 union select a1,b1,c1 union select a1,b1,c1 ..............
insert into tablename (a1,b1,c1) select a1,b1,c1 union select a1,b1,c1 union select a1,b1,c1 union select a1,b1,c1 union select a1,b1,c1 union select a1,b1,c1 union select a1,b1,c1 .............. 能不能写个例子呢~谢谢
select a1,b1,c1 from tablename2 where ………………
select a1,b1,c1 union
select a1,b1,c1 union
select a1,b1,c1 union
select a1,b1,c1 union
select a1,b1,c1 union
select a1,b1,c1 union
select a1,b1,c1 ..............
select a1,b1,c1 union
select a1,b1,c1 union
select a1,b1,c1 union
select a1,b1,c1 union
select a1,b1,c1 union
select a1,b1,c1 union
select a1,b1,c1 ..............
能不能写个例子呢~谢谢