mysql auto_increment建表_我用mysql创建了一个表，并且把ID设置成了主键，和auto_increment，输入不了数据...

createtableusers(userIdintprimarykeyauto_increment,usernamevarchar(20),passwdvarchar(20),emailvarchar(30),gradeint);insertintousersvalues('admin','admin','admin@sufu.com'...

create table users(

userId int primary key auto_increment,

username varchar(20),

passwd varchar(20),

email varchar(30),

grade int);insert into users values('admin','admin','admin@sufu.com',1)

insert into users values('tester1','tester1','tester1@sofu.com',5)

insert into users values('tester2','tester2','tester2@sofu.com',5)

insert into users values('tester3','tester3','tester3@sofu.com',5)

insert into users values('tester4','tester4','tester4@sofu.com',5)

insert into users values('tester5','tester5','tester5@sofu.com',5)

insert into users values('tester6','tester6','tester6@sofu.com',5)

insert into users values('tester7','tester7','tester7@sofu.com',5)

insert into users values('tester8','tester8','tester8@sofu.com',5)

insert into users values('tester9','tester9','tester9@sofu.com',5)

insert into users values('tester0','tester0','tester0@sofu.com',5);

上面是我的表数据，出现的错误是：ERROR 1136 (21S01): Column count doesn't match value count at row 1

展开