delete t1,t2 from vcms_mainfo as t1 left join vcms_article as t2 on t1.id=t2.aid where t2.aid>4000 and t2.aid<100000
sql之left join、right join、inner join的区别转自http://www.cnblogs.com/pcjim/articles/799302.html
left join(左联接) 返回包括左表中的所有记录和右表中联结字段相等的记录
right join(右联接) 返回包括右表中的所有记录和左表中联结字段相等的记录
1 批量替换表里的指定内容
UPDATE `node` SET `title`= replace( `title`, '公交线路', '邯郸公交线路' ) WHERE `title` LIKE '%公交线路%'
