Home  >  Q&A  >  body text

Creating tables is tip #1286 - Unknown storage engine 'InnoDB'

Create table is prompt#1286 - Unknown storage engine 'InnoDB'

元曦元曦2639 days ago1482

reply all(2)I'll reply

  • 潜轲

    潜轲2017-08-21 23:33:31

    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

    reply
    2
  • 元曦

    元曦2017-08-21 14:15:15

    [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'


    reply
    1
  • Cancelreply