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
展开