杰奇小说创建99个分表，批量执行代码，并且将已经存在数据迁移到分表中

1、在navicat中输入创建命令，因为navicat无法使用批量语句，所以使用下面的php代码生成执行代码

<?php
// 循环生成 99 个 CREATE TABLE 语句
for ($i = 1; $i <= 99; $i++) {
    // 构造每个表的 CREATE TABLE 语句
    $sql = "CREATE TABLE jieqi_article_chapter_$i LIKE jieqi_article_chapter;";
    echo $sql . "\n"; // 输出 SQL 语句
}
?>

生成后的代码如下：

CREATE TABLE jieqi_article_chapter_1 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_2 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_3 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_4 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_5 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_6 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_7 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_8 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_9 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_10 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_11 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_12 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_13 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_14 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_15 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_16 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_17 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_18 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_19 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_20 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_21 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_22 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_23 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_24 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_25 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_26 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_27 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_28 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_29 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_30 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_31 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_32 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_33 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_34 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_35 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_36 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_37 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_38 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_39 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_40 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_41 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_42 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_43 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_44 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_45 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_46 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_47 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_48 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_49 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_50 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_51 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_52 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_53 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_54 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_55 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_56 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_57 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_58 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_59 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_60 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_61 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_62 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_63 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_64 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_65 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_66 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_67 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_68 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_69 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_70 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_71 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_72 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_73 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_74 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_75 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_76 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_77 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_78 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_79 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_80 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_81 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_82 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_83 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_84 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_85 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_86 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_87 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_88 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_89 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_90 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_91 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_92 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_93 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_94 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_95 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_96 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_97 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_98 LIKE jieqi_article_chapter;
CREATE TABLE jieqi_article_chapter_99 LIKE jieqi_article_chapter;

将生成的代码存放到后缀为sql的文件中，比如fenbiao.sql

2、打开数据库-双击数据库名打开-右键数据库名-运行SQL文件

如果已经存在分表了会报错，可以手动修改下执行代码，将已经存在分表的的对应生成分表代码删除即可。

成功后输出下面内容

刷新数据库，发现已经成功创建

3、迁移数据。

使用下面的命令，存储到sql文件中，比如：qianyi.sql

INSERT INTO jieqi_article_chapter_1
SELECT * FROM jieqi_article_chapter
WHERE CEIL(articleid / 10000) = 1;

和上面一样的执行该sql，使用navicat的好处就是不会超时。

上面的是会将书号1-10000的迁移到分表1中

如果你有更多的数据，等上面的执行完成后，继续修改代码

INSERT INTO jieqi_article_chapter_2
SELECT * FROM jieqi_article_chapter
WHERE CEIL(articleid / 10000) = 2;

上面的是书号10001-20000的迁移到分表2中

后面的更多一样的操作，直到把数据都迁移完成即可。

到此为止。