mysql merge table

最新推荐文章于 2025-03-11 09:07:49 发布

阿奇XS

最新推荐文章于 2025-03-11 09:07:49 发布

阅读量1k

点赞数

分类专栏： MySQL 文章标签： mysql merge

MySQL 专栏收录该内容

14 篇文章

订阅专栏

本文通过具体的SQL语句展示了如何进行数据库表结构的优化，包括创建新表、数据迁移及索引设计等内容，对于理解数据库性能调优具有一定参考价值。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT COUNT(*) FROM `comment` 

SHOW CREATE TABLE `comment`

CREATE TABLE `comment1` (
  `id` INT(8) NOT NULL AUTO_INCREMENT,
  `blogUser` VARCHAR(20) NOT NULL,
  `replayUser` VARCHAR(20) NOT NULL,
  `articleId` INT(8) NOT NULL DEFAULT '0',
  `content` TEXT,
  `addTime` DATETIME NOT NULL,
  PRIMARY KEY (`id`),
  KEY `addTime` (`addTime`),
  KEY `replayUser` (`replayUser`)
) ENGINE=MYISAM AUTO_INCREMENT=1000004 DEFAULT CHARSET=utf8
INSERT INTO comment1 SELECT  `id` ,
  `blogUser`,
  `replayUser`,
  `articleId` ,
  `content` ,
  `addTime`
FROM `comment` LIMIT 0,500003

CREATE TABLE `comment2` (
  `id` INT(8) NOT NULL AUTO_INCREMENT,
  `blogUser` VARCHAR(20) NOT NULL,
  `replayUser` VARCHAR(20) NOT NULL,
  `articleId` INT(8) NOT NULL DEFAULT '0',
  `content` TEXT,
  `addTime` DATETIME NOT NULL,
  PRIMARY KEY (`id`),
  KEY `addTime` (`addTime`),
  KEY `replayUser` (`replayUser`)
) ENGINE=MYISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8

INSERT INTO comment1 SELECT  `id` ,
  `blogUser`,
  `replayUser`,
  `articleId` ,
  `content` ,
  `addTime`
FROM `comment` LIMIT 500003,60000000

CREATE TABLE `allcomment` (
  `id` INT(8) NOT NULL AUTO_INCREMENT,
  `blogUser` VARCHAR(20) NOT NULL,
  `replayUser` VARCHAR(20) NOT NULL,
  `articleId` INT(8) NOT NULL DEFAULT '0',
  `content` TEXT,
  `addTime` DATETIME NOT NULL,
  PRIMARY KEY (`id`),
  KEY `addTime` (`addTime`),
  KEY `replayUser` (`replayUser`)
) ENGINE=MERGE UNION (comment1, comment2) INSERT_METHOD=LAST AUTO_INCREMENT=1 ; 

SELECT COUNT(*) FROM `allcomment`