运行MySQL CREATE TABLE语句时出现语法错误 [英] Syntax error when running a MySQL CREATE TABLE statement

问题描述

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

这篇关于运行MySQL CREATE TABLE语句时出现语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！