具体的步骤参考内容：
插入数据时分表也同步插入数据
更新代码可以使用php批量生成
<?php
// PHP Script to generate complete update trigger for 99 tables
// Table name pattern and columns list
$table_columns = [
'chapterid', 'siteid', 'sourceid', 'sourcecid', 'sourcecorder', 'articleid', 'articlename', 'volumeid', 'posterid', 'poster', 'postdate', 'lastupdate',
'chaptername', 'chapterorder', 'size', 'saleprice', 'salenum', 'totalcost', 'attachment', 'summary', 'isimage', 'isvip', 'pages', 'chaptertype', 'power', 'display'
];
// Start the trigger creation script
$trigger_sql = "DELIMITER $$\n\n";
$trigger_sql .= "CREATE TRIGGER after_update_jieqi_article_chapter\n";
$trigger_sql .= "AFTER UPDATE ON jieqi_article_chapter\n";
$trigger_sql .= "FOR EACH ROW\n";
$trigger_sql .= "BEGIN\n";
// Start with the first condition using IF, not ELSEIF
$trigger_sql .= " IF OLD.articleid BETWEEN 1 AND 10000 THEN\n";
$trigger_sql .= " UPDATE jieqi_article_chapter_1 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;\n";
// Loop through 99 tables and create update statements dynamically
for ($i = 2; $i <= 99; $i++) {
// Determine the range of articleid for each table
$start_articleid = ($i - 1) * 10000 + 1;
$end_articleid = $i * 10000;
// Prepare the update statement for each table
$trigger_sql .= " ELSEIF OLD.articleid BETWEEN $start_articleid AND $end_articleid THEN\n";
$trigger_sql .= " UPDATE jieqi_article_chapter_$i SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;\n";
}
// Close the trigger SQL
$trigger_sql .= " END IF;\n";
$trigger_sql .= "END $$\n";
$trigger_sql .= "DELIMITER ;\n";
// Output the generated trigger SQL
echo $trigger_sql;
?>
其中$table_columns里面对应的参数是表jieqi_article_chapter对应的列名
使用下面sql查询语句进行查询
DESCRIBE jieqi_article_chapter;生成的代码如下：
DELIMITER $$
CREATE TRIGGER after_update_jieqi_article_chapter
AFTER UPDATE ON jieqi_article_chapter
FOR EACH ROW
BEGIN
IF OLD.articleid BETWEEN 1 AND 10000 THEN
UPDATE jieqi_article_chapter_1 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 10001 AND 20000 THEN
UPDATE jieqi_article_chapter_2 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 20001 AND 30000 THEN
UPDATE jieqi_article_chapter_3 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 30001 AND 40000 THEN
UPDATE jieqi_article_chapter_4 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 40001 AND 50000 THEN
UPDATE jieqi_article_chapter_5 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 50001 AND 60000 THEN
UPDATE jieqi_article_chapter_6 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 60001 AND 70000 THEN
UPDATE jieqi_article_chapter_7 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 70001 AND 80000 THEN
UPDATE jieqi_article_chapter_8 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 80001 AND 90000 THEN
UPDATE jieqi_article_chapter_9 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 90001 AND 100000 THEN
UPDATE jieqi_article_chapter_10 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 100001 AND 110000 THEN
UPDATE jieqi_article_chapter_11 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 110001 AND 120000 THEN
UPDATE jieqi_article_chapter_12 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 120001 AND 130000 THEN
UPDATE jieqi_article_chapter_13 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 130001 AND 140000 THEN
UPDATE jieqi_article_chapter_14 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 140001 AND 150000 THEN
UPDATE jieqi_article_chapter_15 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 150001 AND 160000 THEN
UPDATE jieqi_article_chapter_16 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 160001 AND 170000 THEN
UPDATE jieqi_article_chapter_17 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 170001 AND 180000 THEN
UPDATE jieqi_article_chapter_18 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 180001 AND 190000 THEN
UPDATE jieqi_article_chapter_19 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 190001 AND 200000 THEN
UPDATE jieqi_article_chapter_20 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 200001 AND 210000 THEN
UPDATE jieqi_article_chapter_21 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 210001 AND 220000 THEN
UPDATE jieqi_article_chapter_22 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 220001 AND 230000 THEN
UPDATE jieqi_article_chapter_23 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 230001 AND 240000 THEN
UPDATE jieqi_article_chapter_24 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 240001 AND 250000 THEN
UPDATE jieqi_article_chapter_25 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 250001 AND 260000 THEN
UPDATE jieqi_article_chapter_26 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 260001 AND 270000 THEN
UPDATE jieqi_article_chapter_27 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 270001 AND 280000 THEN
UPDATE jieqi_article_chapter_28 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 280001 AND 290000 THEN
UPDATE jieqi_article_chapter_29 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 290001 AND 300000 THEN
UPDATE jieqi_article_chapter_30 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 300001 AND 310000 THEN
UPDATE jieqi_article_chapter_31 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 310001 AND 320000 THEN
UPDATE jieqi_article_chapter_32 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 320001 AND 330000 THEN
UPDATE jieqi_article_chapter_33 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 330001 AND 340000 THEN
UPDATE jieqi_article_chapter_34 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 340001 AND 350000 THEN
UPDATE jieqi_article_chapter_35 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 350001 AND 360000 THEN
UPDATE jieqi_article_chapter_36 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 360001 AND 370000 THEN
UPDATE jieqi_article_chapter_37 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 370001 AND 380000 THEN
UPDATE jieqi_article_chapter_38 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 380001 AND 390000 THEN
UPDATE jieqi_article_chapter_39 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 390001 AND 400000 THEN
UPDATE jieqi_article_chapter_40 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 400001 AND 410000 THEN
UPDATE jieqi_article_chapter_41 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 410001 AND 420000 THEN
UPDATE jieqi_article_chapter_42 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 420001 AND 430000 THEN
UPDATE jieqi_article_chapter_43 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 430001 AND 440000 THEN
UPDATE jieqi_article_chapter_44 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 440001 AND 450000 THEN
UPDATE jieqi_article_chapter_45 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 450001 AND 460000 THEN
UPDATE jieqi_article_chapter_46 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 460001 AND 470000 THEN
UPDATE jieqi_article_chapter_47 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 470001 AND 480000 THEN
UPDATE jieqi_article_chapter_48 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 480001 AND 490000 THEN
UPDATE jieqi_article_chapter_49 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 490001 AND 500000 THEN
UPDATE jieqi_article_chapter_50 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 500001 AND 510000 THEN
UPDATE jieqi_article_chapter_51 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 510001 AND 520000 THEN
UPDATE jieqi_article_chapter_52 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 520001 AND 530000 THEN
UPDATE jieqi_article_chapter_53 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 530001 AND 540000 THEN
UPDATE jieqi_article_chapter_54 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 540001 AND 550000 THEN
UPDATE jieqi_article_chapter_55 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 550001 AND 560000 THEN
UPDATE jieqi_article_chapter_56 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 560001 AND 570000 THEN
UPDATE jieqi_article_chapter_57 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 570001 AND 580000 THEN
UPDATE jieqi_article_chapter_58 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 580001 AND 590000 THEN
UPDATE jieqi_article_chapter_59 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 590001 AND 600000 THEN
UPDATE jieqi_article_chapter_60 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 600001 AND 610000 THEN
UPDATE jieqi_article_chapter_61 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 610001 AND 620000 THEN
UPDATE jieqi_article_chapter_62 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 620001 AND 630000 THEN
UPDATE jieqi_article_chapter_63 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 630001 AND 640000 THEN
UPDATE jieqi_article_chapter_64 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 640001 AND 650000 THEN
UPDATE jieqi_article_chapter_65 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 650001 AND 660000 THEN
UPDATE jieqi_article_chapter_66 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 660001 AND 670000 THEN
UPDATE jieqi_article_chapter_67 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 670001 AND 680000 THEN
UPDATE jieqi_article_chapter_68 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 680001 AND 690000 THEN
UPDATE jieqi_article_chapter_69 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 690001 AND 700000 THEN
UPDATE jieqi_article_chapter_70 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 700001 AND 710000 THEN
UPDATE jieqi_article_chapter_71 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 710001 AND 720000 THEN
UPDATE jieqi_article_chapter_72 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 720001 AND 730000 THEN
UPDATE jieqi_article_chapter_73 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 730001 AND 740000 THEN
UPDATE jieqi_article_chapter_74 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 740001 AND 750000 THEN
UPDATE jieqi_article_chapter_75 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 750001 AND 760000 THEN
UPDATE jieqi_article_chapter_76 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 760001 AND 770000 THEN
UPDATE jieqi_article_chapter_77 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 770001 AND 780000 THEN
UPDATE jieqi_article_chapter_78 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 780001 AND 790000 THEN
UPDATE jieqi_article_chapter_79 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 790001 AND 800000 THEN
UPDATE jieqi_article_chapter_80 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 800001 AND 810000 THEN
UPDATE jieqi_article_chapter_81 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 810001 AND 820000 THEN
UPDATE jieqi_article_chapter_82 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 820001 AND 830000 THEN
UPDATE jieqi_article_chapter_83 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 830001 AND 840000 THEN
UPDATE jieqi_article_chapter_84 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 840001 AND 850000 THEN
UPDATE jieqi_article_chapter_85 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 850001 AND 860000 THEN
UPDATE jieqi_article_chapter_86 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 860001 AND 870000 THEN
UPDATE jieqi_article_chapter_87 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 870001 AND 880000 THEN
UPDATE jieqi_article_chapter_88 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 880001 AND 890000 THEN
UPDATE jieqi_article_chapter_89 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 890001 AND 900000 THEN
UPDATE jieqi_article_chapter_90 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 900001 AND 910000 THEN
UPDATE jieqi_article_chapter_91 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 910001 AND 920000 THEN
UPDATE jieqi_article_chapter_92 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 920001 AND 930000 THEN
UPDATE jieqi_article_chapter_93 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 930001 AND 940000 THEN
UPDATE jieqi_article_chapter_94 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 940001 AND 950000 THEN
UPDATE jieqi_article_chapter_95 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 950001 AND 960000 THEN
UPDATE jieqi_article_chapter_96 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 960001 AND 970000 THEN
UPDATE jieqi_article_chapter_97 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 970001 AND 980000 THEN
UPDATE jieqi_article_chapter_98 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
ELSEIF OLD.articleid BETWEEN 980001 AND 990000 THEN
UPDATE jieqi_article_chapter_99 SET chapterid = NEW.chapterid, siteid = NEW.siteid, sourceid = NEW.sourceid, sourcecid = NEW.sourcecid, sourcecorder = NEW.sourcecorder, articlename = NEW.articlename, volumeid = NEW.volumeid, posterid = NEW.posterid, poster = NEW.poster, postdate = NEW.postdate, lastupdate = NEW.lastupdate, chaptername = NEW.chaptername, chapterorder = NEW.chapterorder, size = NEW.size, saleprice = NEW.saleprice, salenum = NEW.salenum, totalcost = NEW.totalcost, attachment = NEW.attachment, summary = NEW.summary, isimage = NEW.isimage, isvip = NEW.isvip, pages = NEW.pages, chaptertype = NEW.chaptertype, power = NEW.power, display = NEW.display WHERE articleid = OLD.articleid AND chapterid = OLD.chapterid;
END IF;
END $$
DELIMITER ;
执行成功没有报错误，可以去触发器查看。
到此为止。
发布者：彬彬笔记，转载请注明出处：https://www.binbinbiji.com/jianzhanjiaoliu/3643.html
