批量操作SQL

UPDATE `collect_comic` SET `status`=0 WHERE `status`=20 

UPDATE `collect_comic` SET `status`=100 WHERE `status`=20 

UPDATE `collect_comic` as a INNER JOIN 
(
SELECT count(id)as count, collect_pid
FROM `collect_chapter`
WHERE `status` = 1
GROUP BY collect_pid
) as b
on a.id = b.collect_pid
SET a.resolved = b.count;

UPDATE `chapter` SET `status`=30 WHERE `status`=10;

UPDATE `collect_chapter` SET `status`=0 WHERE `status`=20;

UPDATE `collect_chapter` SET `status`=0 WHERE `status`=20 AND `comic_id`=漫画ID;

UPDATE `collect_chapter` SET `status`=0 WHERE `status`=20 AND `collect_pid`=漫画采集任务ID;

UPDATE `collect_chapter` SET `status`=0 WHERE `id` IN ( ID1,ID2,ID3);

UPDATE `collect_chapter`
LEFT JOIN `chapter` 
ON `collect_chapter`.chapter_id = `chapter`.`id`
SET `collect_chapter`.`status` = 0
WHERE
`chapter`.`status` != 1;

UPDATE `collect_chapter` SET `status`=100 WHERE `status`=20;

UPDATE `collect_chapter`
SET `status` = 0
WHERE
	`status` = 1
AND `chapter_id` IN (
	SELECT
		`id`
	FROM
		`chapter`
	WHERE
		`status` = 1
	AND `images` = '[]'
);

UPDATE `chapter`
SET `status` = 10
WHERE
	`status` = 1
AND `images` = '[]';

UPDATE `collect_image`
SET `source_url` = REPLACE(`source_url`, 'http://img.a.com', 'http://img.b.com')
WHERE INSTR(`source_url`,'http://img.a.com') > 0;

UPDATE `collect_image` SET `status`=0 WHERE `status`=20;

UPDATE `collect_image` SET `status`=0 WHERE `status`=10;

DELETE FROM `collect_image` WHERE `status` = 20;

DELETE
FROM
	chapter
WHERE
comic_id NOT IN (SELECT id FROM comic)

UPDATE `comic` SET `source_site`=8 WHERE `id` BETWEEN 10 AND 20;