收藏 | 举报 2026-01-14 10:03   关注:15   回答:0

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

问题描述:
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;