你有一个错误在你的SQL语法;检查与MySQL服务器版本对应的手册，以获得正确的语法

Question

你的SQL语法有一个错误;查看与MySQL服务器版本对应的手册，查看正确的语法

create table 'spring3'.'employee'(
id int,
firstname varchar (32),
lastname varchar (32),
email varchar (32),
phonenumber varchar (32),
hiredate date,
salary int
);

create table 'spring4'.'product'(
id int,
name varchar (32),
quantity int,
price float,
available boolean
);

Answer 1

我想你的问题在引号里。用途:

create table `spring3`.`employee`(
id int ,
firstname varchar (32),
lastname varchar (32),
email varchar (32),
phonenumber varchar (32),
hiredate date,
salary int ); 

请记住，您的id应该是，而不是null auto_increment和主键。所以你的表格应该是:

create table `spring3`.`employee`(
id int not null auto_increment ,
firstname varchar (32),
lastname varchar (32),
email varchar (32),
phonenumber varchar (32),
hiredate date,
salary int,
Primary key id(`id`) );