日期:2014-05-16  浏览次数:20719 次

mysql使用总结

一、建表错误

在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 修改为ENGINE=InnoDB