MySQL auto increment

scaglietti

MySQL 的auto increment一定要1,2,3,4,5,....??
可以加一些char/int在前面吗？
eg. num1,num2,num3,num4,num5
00000001，00000002，00000003，。。

anakmal

mysql> CREATE TABLE `appldetails` (
-> `applid` mediumint(8) zerofill PRIMARY KEY auto_increment);

mysql> describe appldetails;
+--------+--------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------+--------------------------------+------+-----+---------+----------------+
| applid | mediumint(8) unsigned zerofill | | PRI | NULL | auto_increment |
+--------+--------------------------------+------+-----+---------+----------------+

and then did

mysql> insert into appldetails values ('');
Query OK, 1 row affected (0.02 sec)

mysql> select * from appldetails;
+----------+
| applid |
+----------+
| 00000001 |
+----------+
1 row in set (0.00 sec)