是的,默认情况下,MySQL中的AUTO_INCREMENT将被signed(均为正值和负值)。
让我们首先创建一个表-mysql> create table DemoTable
-> (
-> MyNumber int AUTO_INCREMENT PRIMARY KEY
-> );
Query OK, 0 rows affected (0.45 sec)
使用insert命令在表中插入一些记录。在这里,我们也为AUTO_INCREMENT列设置了负值-mysql> insert into DemoTable values() ;
Query OK, 1 row affected (0.19 sec)
mysql> insert into DemoTable values(-100);
Query OK, 1 row affected (0.12 sec)
mysql> insert into DemoTable values(-300);
Query OK, 1 row affected (0.13 sec)
mysql> insert into DemoTable values(0);
Query OK, 1 row affected (0.18 sec)
使用select语句显示表中的所有记录-mysql> select *from DemoTable;
输出结果+----------+
| MyNumber |
+----------+
| -300 |
| -100 |
| 1 |
| 2 |
+----------+
4 rows in set (0.00 sec)