在Mysql6.0中执行:create table JBPM_BYTEARRAY (ID_ bigint not null auto_increment, NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_)) type=InnoDB;
出现错误:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type=InnoDB' at line 1,
把type=InnoDB去掉,可以成功.
把type=InnoDB改成ENGINE=InnoDB,也可以成功,不知道作用是不是一样.
先谢谢了!
The older term TYPE is supported as a synonym for ENGINE for backward compatibility, but ENGINE is the preferred term and TYPE is deprecated.
你没读一下异常信息吗
出现错误:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type=InnoDB' at line 1,
这不就说明白了，mysql的当前版本不支持使用'type=InnoDB' 这种语法