傑奇小說創建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中

後面的更多一樣的操作，直到把數據都遷移完成即可。

到此為止。