Home >Database >Mysql Tutorial >MySQL里Create Index 能否创建主键 Primary Key_MySQL
MySQL里Create Index 能否创建主键 Primary Key_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:19:271218browse
bitsCN.com
MySQL里Create Index 能否创建主键 Primary Key?
答案：
不能，必须用 Alter table 创建。
MySQL一个索引列最大允许的有效长度，不是列的所有数据都被索引的
MyISAM 是 1000字节
InnoDB 是 767 字节
注意这里是字节。bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Mysql LONGBLOB 类型存储二进制数据 (修改+调试+整理)_MySQLNext article：Mysql LONGTEXT 类型存储大文件(二进制也可以) (修改+调试+整理)_MySQL