utf-8-求解 mysql數據庫第三行錯誤 birthday

求解 mysql數據庫第三行錯誤 birthday

create table user
(
id int primary key aotu_increment,
name varchar(40),
password varchar(40),
email varchar(40),
birthday date
)character set utf8 collate utf8_general_ci;
insert into user(name,password,eamil,birthday) values('zs','123456','[email protected]','1980-12-04');
insert into user(name,password,eamil,birthday) values('lisi','123456','[email protected]','1981-12-04');
insert into user(name,password,eamil,birthday) values('wangwu','123456','[email protected]','1979-12-04');

最佳回答：

create table user
(
id int primary key AUTO_INCREMENT,
name varchar(40),
password varchar(40),
email varchar(40),
birthday date
)character set utf8 collate utf8_general_ci;

insert into user(name,password,email,birthday) values('zs','123456','[email protected]','1980-12-04');
email 不是eamil
而且mySql裡面用的都是二樓說的1左邊的那個符號