Create table is prompt#1286 - Unknown storage engine 'InnoDB'
The storage engine is turned off?
show engines:
Look at the situation of Innodb.
And this line of statement in my.ini
default-storage-engine=INNODB
[SQL] create table s7_note
(
id mediumint unsigned not null auto_increment comment 'Id',
title varchar(100) not null comment '标题',
content longtext not null comment '内容',
addtime datetime default null comment '添加时间',
ip int not null comment 'IP地址',
primary key(id)
)engine=InnoDB default charset utf8 comment '留言表';
[Err] 1286 - Unknown storage engine 'InnoDB'
The storage engine is turned off?
show engines:
Look at the situation of Innodb.
And this line of statement in my.ini
default-storage-engine=INNODB
[SQL] create table s7_note
(
id mediumint unsigned not null auto_increment comment 'Id',
title varchar(100) not null comment '标题',
content longtext not null comment '内容',
addtime datetime default null comment '添加时间',
ip int not null comment 'IP地址',
primary key(id)
)engine=InnoDB default charset utf8 comment '留言表';
[Err] 1286 - Unknown storage engine 'InnoDB'