mysql 已有的表创建索引_Mysql索引篇，在已创建的表中管理索引

最新推荐文章于 2022-07-28 15:08:46 发布

weixin_42166626

最新推荐文章于 2022-07-28 15:08:46 发布

阅读量115

点赞数

文章标签： mysql 已有的表创建索引

本文链接：https://blog.csdn.net/weixin_42166626/article/details/113213556

版权

创建测试表

DROP TABLE IF EXISTS `test_7`;

CREATE TABLE `test_7` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`col1` varchar(50) DEFAULT NULL,

`col2` int(11) DEFAULT NULL,

`col3` varchar(50) DEFAULT NULL,

`col4` int(11) DEFAULT NULL,

`col5` varchar(50) DEFAULT NULL,

`col6` int(11) DEFAULT NULL,

`col7` geometry DEFAULT NOT NULL,

INDEX SingleIdx(col1)

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

插入测试数据

INSERT INTO `test_7` VALUES ('1', 'aaa', '1', 'bbb', '2', 'ccc', '3', GeomFromText('POINT(108.9498710632 34.2588125935)'));

INSERT INTO `test_7` VALUES ('2', 'ddd', '4', 'eee', '5', 'fff', '7', GeomFromText('POINT(108.9498710632 34.2588125935)'));

INSERT INTO `test_7` VALUES ('3', 'ggg', '8', 'hhh', '9', 'iii', '10', GeomFromText('POINT(108.9498710632 34.2588125935)'));

INSERT INTO `test_7` VALUES ('4', 'jjj', '11', 'kkk', '12', 'lll', '13', GeomFromText('POINT(108.9498710632 34.2588125935)'));

INSERT INTO `test_7` VALUES ('5', 'mmm', '14', 'nnn', '15', 'ooo', '16', GeomFromText('POINT(108.9498710632 34.2588125935)'));

INSERT INTO `test_7` VALUES ('6', 'ppp', '17', 'qqq', '18', 'rrr', '19', GeomFromText('POINT(108.9498710632 34.2588125935)'));

INSERT INTO `test_7` VALUES ('7', 'sss', '20', 'ttt', '21', 'uuu', '22', GeomFromText('POINT(108.9498710632 34.2588125935)'));

关注