CREATE TABLE user
(
id BIGINT(20) NOT NULL COMMENT '主键ID',
name VARCHAR(30)NULL DEFAULT NULL COMMENT '姓名',
age INT(11) NULL DEFAULT NULL COMMENT '年龄',
email VARCHAR(50) NULL DEFAULT NULL COMMENT '邮箱',
PRIMARY KEY(id)
);
INSERT INTO USER(id,name,age,email)VALUES
(1,'jone',18,'test1@baomidou.com'),
(2,'jack',20,'test2@baomidou.com'),
(3,'Tom',28,'test3@baomidou.com'),
(4,'Sandy',21,'test4@baomidou.com'),
(5,'Billie',24,'test5@baomidou.com'),
报错如下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 ',
name VARCHAR(30)NULL DEFAULT NULL COMMENT '姓名',
age INT(11) NULL D' at line 3, Time: 0.000000s
哈喽,这里的英文括号错了,有用请点采纳哦
name VARCHAR(30)