search

Home >Database >Mysql Tutorial >mysql版本不同所导致SQL语句执行错误的问题

mysql版本不同所导致SQL语句执行错误的问题

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 15:08:251792browse

TYPE=InnoDB;是旧版本的 在新版本执行时会出现 [Err] 1064 - 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 12 解决方法：ENGINE=InnoDB

TYPE=InnoDB;是旧版本的

在新版本执行时会出现

[Err] 1064 - 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 12


解决方法： ENGINE=InnoDB改为 ENGINE=InnoDB

 ENGINE=InnoDB  AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;



okay

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Oracle体系结构及备份（十八）bg-databaseNext article：PowerDesigner导出SQL，导入到Oracle中查询表结构报“ORA-04043:

Related articles

See more