复制整张表,条件:a表和b表的数据结构是一样的.
insert into a select * from b
拷贝单条数据
insert into a (select '123' as id, temp,temp2 from b where id=10)
复制整张表,条件:a表和b表的数据结构是一样的.
insert into a select * from b
拷贝单条数据
insert into a (select '123' as id, temp,temp2 from b where id=10)