MERGE分表 · 個人筆記

~~~ CREATE TABLE `sbh_artnews` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `unionid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信ID', `nickname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵稱', `headurl` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '頭像路徑', `title` varchar(155) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '標題', `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '類型', `thumbnail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '縮略圖', `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '內容', `create_time` datetime DEFAULT NULL COMMENT '創建時間', `isdisplay` int(11) DEFAULT '0' COMMENT '0正在審核1審核通過2審核未通過', `bid` int(20) DEFAULT '0' COMMENT '文章類別：0發布文章1廣告文章2置頂文章', `swa` bigint(10) DEFAULT '0' COMMENT '閱讀量', `collect` bigint(10) DEFAULT '0' COMMENT '收藏量', `like` bigint(11) DEFAULT '0' COMMENT '點贊量', `company` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '公司名稱', `audit_user` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '審核專員', `audit_time` datetime DEFAULT NULL COMMENT '審核時間', `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '地址', PRIMARY KEY (`id`) ) ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8mb4 INSERT_METHOD=LAST UNION=(`sbh_artnews0`,`sbh_artnews1`,`sbh_artnews2`,`sbh_artnews3`,`sbh_artnews4`,`sbh_artnews5`,`sbh_artnews6`,`sbh_artnews7`,`sbh_artnews8`,`sbh_artnews9`); ~~~