- 积分
- 63
- UID
- 378
- 阅读权限
- 20
- 注册时间
- 2008-4-11
- 精华
- 在线时间
- 小时
- 最后登录
- 1970-1-1
- 职业
- 5
|
当执行角本会报错时,把default '0'改成default 0。但如果不报错时,肯定是可以插入默认值的啊。
CREATE TABLE IF NOT EXISTS test (
`id` int(10) NOT NULL auto_increment,
`member_id` smallint(5) default NULL,
`picture` varchar(255) default NULL,
`fir` SMALLINT(6) NOT NULL default '0',
`nr` SMALLINT(6) NOT NULL default '0',
`sr` SMALLINT(6) NOT NULL default '0',
`ar` SMALLINT(6) NOT NULL default '0',
`frr` SMALLINT(6) NOT NULL default '0',
PRIMARY KEY (`id`)
);
insert into test(id) values(1);
select * from test;
结果如下(完全OK的):
+----+-----------+---------+-----+----+----+----+-----+
| id | member_id | picture | fir | nr | sr | ar | frr |
+----+-----------+---------+-----+----+----+----+-----+
| 1 | NULL | NULL | 0 | 0 | 0 | 0 | 0 |
+----+-----------+---------+-----+----+----+----+-----+
1 row in set (0.00 sec) |
|