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