插入出错

[小曦子]

create database jhonny default character set gb2312;
grant all privileges on jhonny.* to jhonny@localhost IDENTIFIED BY 'jhonny_74513210' WITH GRANT OPTION;
use jhonny;
create table user(
userID int unsigned auto_increment,
userName char(10) not null,
userType int unsigned default 0,
password char(20) not null,
phone char(30),
qq char(20),
addr char(50),
primary key(userID)
);
insert into user(userName,userType,password) values('ytfsse','1','74513210');
insert into user(userName,userType,password) values('ytfsse1','1','74513210');
insert into user(userName,userType,password) values('ytfsse2','1','74513210');
insert into user(userName,userType,password) values('ytfsse3','1','74513210');

create table matter(
userName char(10) not null,
note varchar(1000) not null,
noteDate datetime,
primary key(userName)

);

create view matterView as select
matter.*
from matter;

insert into matter(userName,note,) values('ytfsse','564646464634');
insert into matter(userName,note,) values('ytfsse1','564646464634');
insert into matter(userName,note,) values('ytfsse2','564646464634');
insert into matter(userName,note,) values('ytfsse3','564646464634');

为什么最后那四行插入会出错呀???

[cuike519]

==>insert into matter(userName,note,) values('ytfsse','564646464634');

insert into matter(userName,note) values('ytfsse','564646464634');
多个逗号。。。

[楼外楼]

insert into matter(userName,note) values('ytfsse3','564646464634');
多了个逗号

[skeljy]

lz 粗心类！

[jiang_jiajia10]

insert into matter(userName,note,) values('ytfsse1','564646464634');
insert into matter(userName,note,) values('ytfsse2','564646464634');
insert into matter(userName,note,) values('ytfsse3','564646464634');
粗心的LZ.

[xupeihuagudulei]

[Quote=引用 4 楼 jiang_jiajia10 的回复:]
insert into matter(userName,note,) values('ytfsse1','564646464634');
insert into matter(userName,note,) values('ytfsse2','564646464634');
insert into matter(userName,note,) values('ytfsse3','564646464634');
粗心的LZ.
[/Quote]
顶

[qinhl99]

哈哈,接分!

[ttg520]

jf

[ReyZhang]

jf

[yumi_yu]

lz是否都是用复制黏贴的呢~~~

[Wayne]

下次少加个逗号

[小曦子]

看来是多了个逗号呀