运行MySQL CREATE TABLE语句时出现语法错误

本文介绍了运行MySQL CREATE TABLE语句时出现语法错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 CREATE TABLE users ( user_id INT(8) NOT NULL AUTO_INCREMENT, user_name VARCHAR(30) NOT NULL, user_pass VARCHAR(255) NOT NULL, user_email VARCHAR(255) NOT NULL, user_date DATETIME NOT NULL, user_level INT(8) NOT NULL, UNIQUE INDEX user_name_unique (user_name), PRIMARY KEY (user_id) ) TYPE=INNODB;

在SQL服务器上运行此查询时，会收到以下错误：

When running this query on the SQL server, I am getting the following error:

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 10

任何有关为什么会出现的帮助？

Any help on why this is coming up?

推荐答案

$ b

Instead of

TYPE=INNODB

设置

Engine=InnoDB