在表A中含有下面的字段:
`sequenceid` INTEGER(11) UNSIGNED NOT NULL AUTO_INCREMENT,
此时无法插入数据
把此字段改成
`sequenceid` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
即可插入数据,为什么?
MySQL5
`sequenceid` INTEGER(11) UNSIGNED NOT NULL AUTO_INCREMENT,
此时无法插入数据
把此字段改成
`sequenceid` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
即可插入数据,为什么?
MySQL5
-> `sequenceid` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT primary key);
Query OK, 0 rows affected (0.25 sec)mysql> insert into a values(null);
Query OK, 1 row affected (0.06 sec)mysql> select * from a;
+------------+
| sequenceid |
+------------+
| 1 |
+------------+
1 row in set (0.00 sec)