今天用编写一个create table sql语句执行竟然报错,今天mysql创建表报错#1071 - Specified key was too long; max key length is 767 bytes,请问是什么原因?sql为:
CREATE TABLE `items` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id', `title` varchar(255) NOT NULL COMMENT '名称', `atime` int(11) NOT NULL COMMENT '添加时间',UNIQUE INDEX (`title`),PRIMARY KEY (`id`))ENGINE = INNODB
网友回复