mysql中两个表的合并问题

Question

本帖最后由 mengoi321 于 2010-07-08 17:58:17 编辑

Answer 1

试试:
insert into A (pid,fid,tid,first,subject,message,author) select pid,fid,tid,first,subject,message,author from B;

Answer 2

 不好意思，好像反了
insert into B (pid,fid,tid,first,subject,message,author) select pid,fid,tid,first,subject,message,author from A;

Answer 3

如二楼这样，把字段名列即可。insert into b (pid,fid,tid,first,subject,message,author) 
select pid,fid,tid,first,subject,message,author from a;