具体的步骤参考内容:
插入代码可以使用php批量生成
<?php
// PHP Script to generate complete insert 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_insert_jieqi_article_chapter\n";
$trigger_sql .= "AFTER INSERT 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 NEW.articleid BETWEEN 1 AND 10000 THEN\n";
$trigger_sql .= " INSERT INTO jieqi_article_chapter_1 (" . implode(', ', $table_columns) . ")\n";
$trigger_sql .= " VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);\n";
// Loop through 99 tables and create insert 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 insert statement for each table
$trigger_sql .= " ELSEIF NEW.articleid BETWEEN $start_articleid AND $end_articleid THEN\n";
$trigger_sql .= " INSERT INTO jieqi_article_chapter_$i (" . implode(', ', $table_columns) . ")\n";
$trigger_sql .= " VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);\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_insert_jieqi_article_chapter
AFTER INSERT ON jieqi_article_chapter
FOR EACH ROW
BEGIN
IF NEW.articleid BETWEEN 1 AND 10000 THEN
INSERT INTO jieqi_article_chapter_1 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 10001 AND 20000 THEN
INSERT INTO jieqi_article_chapter_2 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 20001 AND 30000 THEN
INSERT INTO jieqi_article_chapter_3 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 30001 AND 40000 THEN
INSERT INTO jieqi_article_chapter_4 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 40001 AND 50000 THEN
INSERT INTO jieqi_article_chapter_5 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 50001 AND 60000 THEN
INSERT INTO jieqi_article_chapter_6 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 60001 AND 70000 THEN
INSERT INTO jieqi_article_chapter_7 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 70001 AND 80000 THEN
INSERT INTO jieqi_article_chapter_8 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 80001 AND 90000 THEN
INSERT INTO jieqi_article_chapter_9 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 90001 AND 100000 THEN
INSERT INTO jieqi_article_chapter_10 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 100001 AND 110000 THEN
INSERT INTO jieqi_article_chapter_11 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 110001 AND 120000 THEN
INSERT INTO jieqi_article_chapter_12 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 120001 AND 130000 THEN
INSERT INTO jieqi_article_chapter_13 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 130001 AND 140000 THEN
INSERT INTO jieqi_article_chapter_14 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 140001 AND 150000 THEN
INSERT INTO jieqi_article_chapter_15 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 150001 AND 160000 THEN
INSERT INTO jieqi_article_chapter_16 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 160001 AND 170000 THEN
INSERT INTO jieqi_article_chapter_17 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 170001 AND 180000 THEN
INSERT INTO jieqi_article_chapter_18 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 180001 AND 190000 THEN
INSERT INTO jieqi_article_chapter_19 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 190001 AND 200000 THEN
INSERT INTO jieqi_article_chapter_20 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 200001 AND 210000 THEN
INSERT INTO jieqi_article_chapter_21 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 210001 AND 220000 THEN
INSERT INTO jieqi_article_chapter_22 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 220001 AND 230000 THEN
INSERT INTO jieqi_article_chapter_23 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 230001 AND 240000 THEN
INSERT INTO jieqi_article_chapter_24 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 240001 AND 250000 THEN
INSERT INTO jieqi_article_chapter_25 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 250001 AND 260000 THEN
INSERT INTO jieqi_article_chapter_26 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 260001 AND 270000 THEN
INSERT INTO jieqi_article_chapter_27 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 270001 AND 280000 THEN
INSERT INTO jieqi_article_chapter_28 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 280001 AND 290000 THEN
INSERT INTO jieqi_article_chapter_29 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 290001 AND 300000 THEN
INSERT INTO jieqi_article_chapter_30 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 300001 AND 310000 THEN
INSERT INTO jieqi_article_chapter_31 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 310001 AND 320000 THEN
INSERT INTO jieqi_article_chapter_32 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 320001 AND 330000 THEN
INSERT INTO jieqi_article_chapter_33 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 330001 AND 340000 THEN
INSERT INTO jieqi_article_chapter_34 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 340001 AND 350000 THEN
INSERT INTO jieqi_article_chapter_35 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 350001 AND 360000 THEN
INSERT INTO jieqi_article_chapter_36 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 360001 AND 370000 THEN
INSERT INTO jieqi_article_chapter_37 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 370001 AND 380000 THEN
INSERT INTO jieqi_article_chapter_38 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 380001 AND 390000 THEN
INSERT INTO jieqi_article_chapter_39 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 390001 AND 400000 THEN
INSERT INTO jieqi_article_chapter_40 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 400001 AND 410000 THEN
INSERT INTO jieqi_article_chapter_41 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 410001 AND 420000 THEN
INSERT INTO jieqi_article_chapter_42 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 420001 AND 430000 THEN
INSERT INTO jieqi_article_chapter_43 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 430001 AND 440000 THEN
INSERT INTO jieqi_article_chapter_44 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 440001 AND 450000 THEN
INSERT INTO jieqi_article_chapter_45 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 450001 AND 460000 THEN
INSERT INTO jieqi_article_chapter_46 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 460001 AND 470000 THEN
INSERT INTO jieqi_article_chapter_47 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 470001 AND 480000 THEN
INSERT INTO jieqi_article_chapter_48 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 480001 AND 490000 THEN
INSERT INTO jieqi_article_chapter_49 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 490001 AND 500000 THEN
INSERT INTO jieqi_article_chapter_50 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 500001 AND 510000 THEN
INSERT INTO jieqi_article_chapter_51 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 510001 AND 520000 THEN
INSERT INTO jieqi_article_chapter_52 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 520001 AND 530000 THEN
INSERT INTO jieqi_article_chapter_53 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 530001 AND 540000 THEN
INSERT INTO jieqi_article_chapter_54 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 540001 AND 550000 THEN
INSERT INTO jieqi_article_chapter_55 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 550001 AND 560000 THEN
INSERT INTO jieqi_article_chapter_56 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 560001 AND 570000 THEN
INSERT INTO jieqi_article_chapter_57 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 570001 AND 580000 THEN
INSERT INTO jieqi_article_chapter_58 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 580001 AND 590000 THEN
INSERT INTO jieqi_article_chapter_59 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 590001 AND 600000 THEN
INSERT INTO jieqi_article_chapter_60 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 600001 AND 610000 THEN
INSERT INTO jieqi_article_chapter_61 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 610001 AND 620000 THEN
INSERT INTO jieqi_article_chapter_62 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 620001 AND 630000 THEN
INSERT INTO jieqi_article_chapter_63 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 630001 AND 640000 THEN
INSERT INTO jieqi_article_chapter_64 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 640001 AND 650000 THEN
INSERT INTO jieqi_article_chapter_65 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 650001 AND 660000 THEN
INSERT INTO jieqi_article_chapter_66 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 660001 AND 670000 THEN
INSERT INTO jieqi_article_chapter_67 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 670001 AND 680000 THEN
INSERT INTO jieqi_article_chapter_68 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 680001 AND 690000 THEN
INSERT INTO jieqi_article_chapter_69 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 690001 AND 700000 THEN
INSERT INTO jieqi_article_chapter_70 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 700001 AND 710000 THEN
INSERT INTO jieqi_article_chapter_71 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 710001 AND 720000 THEN
INSERT INTO jieqi_article_chapter_72 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 720001 AND 730000 THEN
INSERT INTO jieqi_article_chapter_73 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 730001 AND 740000 THEN
INSERT INTO jieqi_article_chapter_74 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 740001 AND 750000 THEN
INSERT INTO jieqi_article_chapter_75 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 750001 AND 760000 THEN
INSERT INTO jieqi_article_chapter_76 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 760001 AND 770000 THEN
INSERT INTO jieqi_article_chapter_77 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 770001 AND 780000 THEN
INSERT INTO jieqi_article_chapter_78 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 780001 AND 790000 THEN
INSERT INTO jieqi_article_chapter_79 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 790001 AND 800000 THEN
INSERT INTO jieqi_article_chapter_80 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 800001 AND 810000 THEN
INSERT INTO jieqi_article_chapter_81 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 810001 AND 820000 THEN
INSERT INTO jieqi_article_chapter_82 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 820001 AND 830000 THEN
INSERT INTO jieqi_article_chapter_83 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 830001 AND 840000 THEN
INSERT INTO jieqi_article_chapter_84 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 840001 AND 850000 THEN
INSERT INTO jieqi_article_chapter_85 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 850001 AND 860000 THEN
INSERT INTO jieqi_article_chapter_86 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 860001 AND 870000 THEN
INSERT INTO jieqi_article_chapter_87 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 870001 AND 880000 THEN
INSERT INTO jieqi_article_chapter_88 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 880001 AND 890000 THEN
INSERT INTO jieqi_article_chapter_89 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 890001 AND 900000 THEN
INSERT INTO jieqi_article_chapter_90 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 900001 AND 910000 THEN
INSERT INTO jieqi_article_chapter_91 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 910001 AND 920000 THEN
INSERT INTO jieqi_article_chapter_92 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 920001 AND 930000 THEN
INSERT INTO jieqi_article_chapter_93 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 930001 AND 940000 THEN
INSERT INTO jieqi_article_chapter_94 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 940001 AND 950000 THEN
INSERT INTO jieqi_article_chapter_95 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 950001 AND 960000 THEN
INSERT INTO jieqi_article_chapter_96 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 960001 AND 970000 THEN
INSERT INTO jieqi_article_chapter_97 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 970001 AND 980000 THEN
INSERT INTO jieqi_article_chapter_98 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
ELSEIF NEW.articleid BETWEEN 980001 AND 990000 THEN
INSERT INTO jieqi_article_chapter_99 (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)
VALUES (NEW.chapterid, NEW.siteid, NEW.sourceid, NEW.sourcecid, NEW.sourcecorder, NEW.articleid, NEW.articlename, NEW.volumeid, NEW.posterid, NEW.poster, NEW.postdate, NEW.lastupdate, NEW.chaptername, NEW.chapterorder, NEW.size, NEW.saleprice, NEW.salenum, NEW.totalcost, NEW.attachment, NEW.summary, NEW.isimage, NEW.isvip, NEW.pages, NEW.chaptertype, NEW.power, NEW.display);
END IF;
END $$
DELIMITER ;
执行成功后如下

最后测试后发现一切正常。
到此为止。
发布者:彬彬笔记,转载请注明出处:https://www.binbinbiji.com/jianzhanjiaoliu/3640.html