说我语法错误

来源:3-5 表设计进阶课程自测

慕粉13691677711

2022-04-17

CREATE TABLE stduent_info_table(
study_id INT NOT NULL AUTO_INCREMENT,
student_name VARCHAR(255) NOT NULL,
student_sex ENUM(‘男’, ‘女’) DEFAULT ‘男’,
student_age INT NOT NULL,
student_class VARCHAR(255) NOT NULL,
student_address VARCHAR(255) NOT NULL,
student_phone CHAR(11) NOT NULL,
PRIMARY KEY(study_id),
)

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 ‘)’ at line 10

写回答

1回答

慕粉13691677711

提问者

2022-04-20

最后一行,PRIMARY KEY(study_id)多了个逗号
下载视频          
1
0

Python操作三大主流数据库 实战网易新闻客户端

零基础快速进阶,专为只懂Python语法的同学设计

432 学习 · 116 问题

查看课程