insert into addonarticle select * from th_addonarticle 复制表

insert into arctiny(id,senddate)
select `wz_id`+455,addtime
from  wenzhang   往目标表里插数据

mysql 合并表时用到的sql语句
一个笨方法：把两个或多个表放到一个库里面操作方便一点，把目标表备份弄个临时表然后把数据插入临时表，测试没问题表改名。
上面sql的 在10W数据的文章表里很块


删除重复行
delete neturl as a from neturl as a,(select * from neturl group by url having count(1)>1) as b where a.url=b.url and a.id > b.id

查询去除重复行
select *, count(distinct name) from table group by name

弱鸟一个