关于插入记录，新手问题，各位大牛帮忙看下

[Kylin_Bird_Lee]

存储语句如下：
insert into chardata (
accountid,
level,
sex,
headimg,
action_id,
race,
currentexperience,
job_id,
attr_bear,
attr_soma,
attr_unreal,
attr_force,
attr_virtuous,
attr_refined,
attr_speed,
attr_impress,
hp,
mp,
perception,
pos_x,
pos_y,
faceto) values
("17,0,0,2,6,4,0,1,
0,0,0,0,0,0,0,0,
1000,500,0,156,591,1");

表结构：
/*Table structure for table `chardata` */

DROP TABLE IF EXISTS `chardata`;

CREATE TABLE `chardata` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
`delflag` int(11) NOT NULL DEFAULT '0' COMMENT '0：',
`deletetime` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`dbid` bigint(20) NOT NULL COMMENT 'id',
`accountid` int(11) NOT NULL DEFAULT '0' COMMENT '号',
`name` varchar(32) CHARACTER SET utf8 NOT NULL COMMENT '名字',
`level` int(11) NOT NULL DEFAULT '0' COMMENT '级别',
`sex` int(11) NOT NULL DEFAULT '0' COMMENT '性别。1为男，0为女',
`headimg` int(11) NOT NULL DEFAULT '0' COMMENT '头像',
`action_id` int(11) NOT NULL DEFAULT '0' COMMENT '动',
`race` int(11) NOT NULL DEFAULT '0' COMMENT '族',
`currentexperience` bigint(20) NOT NULL DEFAULT '0' COMMENT '当值',
`job_id` int(11) NOT NULL DEFAULT '0' COMMENT '职业 ',
`job_level` int(11) NOT NULL DEFAULT '0' COMMENT '职业等级',
`ability` int(11) NOT NULL DEFAULT '0' COMMENT '已点',
`attr_bear` int(11) NOT NULL DEFAULT '0' COMMENT '',
`attr_soma` int(11) NOT NULL DEFAULT '0' COMMENT '角色属性',
`attr_unreal` int(11) NOT NULL DEFAULT '0' COMMENT '角色属性',
`attr_force` int(11) NOT NULL DEFAULT '0' COMMENT '角色属性',
`attr_virtuous` int(11) NOT NULL DEFAULT '0' COMMENT '角色属性',
`attr_refined` int(11) NOT NULL DEFAULT '0' COMMENT '角色属性',
`attr_speed` int(11) NOT NULL DEFAULT '0' COMMENT '角色属性',
`attr_impress` int(11) NOT NULL DEFAULT '0' COMMENT '角色属性',
`hp` int(11) NOT NULL DEFAULT '0' COMMENT '当前',
`mp` int(11) NOT NULL DEFAULT '0' COMMENT '当前',
`perception` int(11) NOT NULL DEFAULT '0' COMMENT '感知',
`ectypeid` int(11) NOT NULL DEFAULT '0' COMMENT '所在的副',
`ectypeinstanceid` int(11) NOT NULL DEFAULT '0' COMMENT '副本实',
`ectypestarttime` bigint(20) NOT NULL DEFAULT '0' COMMENT '副本开',
`mapid` int(11) NOT NULL DEFAULT '0' COMMENT '玩家',
`pos_x` int(11) NOT NULL DEFAULT '0' COMMENT '当前坐标x',
`pos_y` int(11) NOT NULL DEFAULT '0' COMMENT '当前坐标y',
`faceto` int(11) NOT NULL DEFAULT '0' COMMENT '角色朝向。0：',
`money` bigint(20) NOT NULL DEFAULT '0' COMMENT '游',
`evil` int(11) NOT NULL COMMENT '值',
PRIMARY KEY (`dbid`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=120 DEFAULT CHARSET=latin1;


问题：
为什么执行上面的SQL语句后出现如下错误：

错误码: 1136
Column count doesn't match value count at row 1

Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000

[Mr_Bean]

自增就不要给他赋值了吧

[WWWWA]

INSERT INTO chardata (
accountid,
`level`,
sex,
headimg,
action_id,
race,
currentexperience,
job_id,
attr_bear,
attr_soma,
attr_unreal,
attr_force,
attr_virtuous,
attr_refined,
attr_speed,
attr_impress,
hp,
mp,
perception,
pos_x,
pos_y,
faceto) VALUES
(17,0,0,2,6,4,0,1,
0,0,0,0,0,0,0,0,
1000,500,0,156,591,1);
SHOW WARNINGS;
Level Code Message
Warning 1364 Field 'dbid' doesn't have a default value
Warning 1364 Field 'name' doesn't have a default value
Warning 1364 Field 'evil' doesn't have a default value

[Kylin_Bird_Lee]

楼上正解，结贴

[rucypli]

把双引号去掉

mysql> insert into chardata (
-> accountid,
-> level,
-> sex,
-> headimg,
-> action_id,
-> race,
-> currentexperience,
-> job_id,
-> attr_bear,
-> attr_soma,
-> attr_unreal,
-> attr_force,
-> attr_virtuous,
-> attr_refined,
-> attr_speed,
-> attr_impress,
-> hp,
-> mp,
-> perception,
-> pos_x,
-> pos_y,
-> faceto) values
-> (17,0,0,2,6,4,0,1,
-> 0,0,0,0,0,0,0,0,
-> 1000,500,0,156,591,1);
Query OK, 1 row affected, 3 warnings (0.00 sec)