MySql把两张字段相同的表合成一张表

MySql 中两张字段相同的表合成一张表

INSERT INTO a_addonarticle SELECT * FROM a_addonarticle1

 

INSERT INTO sme_article_212 SELECT * FROM sme_article_47

INSERT INTO ask_answer SELECT * FROM ask_answer1

INSERT INTO ask_question SELECT * FROM ask_question1

INSERT INTO wp_term_relationships1 SELECT * FROM wp_term_relationships

INSERT INTO e_term_taxonomy SELECT * FROM wp_term_taxonomy

INSERT INTO phome_ecms_news SELECT * FROM wp_posts

INSERT INTO e_term SELECT * FROM wp_terms

MySQL数据表合并（两表字段相同）

insert into sme_article_212(catid,areaid,level,title,style,fee,subtitle,introduce,tag,keyword,pptword,author,copyfrom,fromurl,voteid,hits,thumb,username,addtime,editor,edittime,ip,template,status,islink,linkurl,filepath,note) select catid,areaid,level,title,style,fee,subtitle,introduce,tag,keyword,pptword,author,copyfrom,fromurl,voteid,hits,thumb,username,addtime,editor,edittime,ip,template,status,islink,linkurl,filepath,note from sme_article_46;

insert into sme_article_data_212(content) select content from sme_article_data_46;