这是怎么回事
来源：2-4 简单慕课用户数据表创建
昵称加载中__
2019-11-02 15:44:18
mysql> CREATE TABLE IF NOT EXISTS user (
-> id INT,
-> username VARCHAR (20),
-> password CHAR (32),
-> emaile VARCHAR(50),
-> age TINYINT,
-> card CHAR(18),
-> tel CHAR (11),
-> salary FLOAT (8,2),
-> marride TINYINT(1),
-> sex ENUM('男','女','保密'),
-> addr VARCHAR (100),
-> )ENGING=INN0DB CHARSET=UTF8;
ERROR 1064 (42000): 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 ')ENGING=INN0DB CHARSET=UTF8' at line 13
mysql>
写回答
1回答
-
好帮手慕小尤
2019-11-02
同学你好，1. 最后一个字段结尾应该没有逗号。
2. ENGINE=INNODB关键词书写错误。修改后代码如下：
CREATE TABLE IF NOT EXISTS user( id INT, username VARCHAR (20), password CHAR (32), emaile VARCHAR(50), age TINYINT, card CHAR(18), tel CHAR (11), salary FLOAT (8,2), marride TINYINT(1), sex ENUM('男','女','保密'), addr VARCHAR (100) )ENGINE=INNODB CHARSET=UTF8;祝学习愉快！
0
相似问题