- 积分
- 35
- UID
- 20621
- 阅读权限
- 10
- 注册时间
- 2015-12-23
- 精华
- 在线时间
- 小时
- 最后登录
- 1970-1-1
- 职业
- 1
|
虽然我已经这么做了,也没有任何报错,但是还是想请问一下,这样是否有问题?如果我再多增加一种索引类型呢?比如,唯一性索引
mysql> CREATE INDEX index_name_single ON example6 (name(10));
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> SHOW CREATE TABLE example6;
+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| example6 | CREATE TABLE `example6` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`stu_id` int(11) DEFAULT NULL,
`name` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `stu_id` (`stu_id`),
KEY `index_name_single` (`name`(10)),
FULLTEXT KEY `index_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
红色前2行是 2种不同的索引 一个单列索引,一个全文索引。
这样没有问题吗?对以后会有什么影响?
|
|