insert into select [SQL]

insert into `d_mx_think`.`su_article` (id,catid,title,url) select id,catid,title,url from d_mx_phpcms.`t_mx_news`;

 

 update `d_mx_think`.`su_article` as a INNER JOIN `d_mx_phpcms`.`t_mx_news_data` as b ON a.id=b.id SET a.content=b.content;