查询b表数据,然后插入a表
1、表结构一样
insert into a select * from b;
2、表结构不一样
insert into a (name,age,address) select user_name,user_age,user_address from b;
查询b表数据,然后插入a表
1、表结构一样
insert into a select * from b;
2、表结构不一样
insert into a (name,age,address) select user_name,user_age,user_address from b;