如何用mysql或Navicat实现流水号的插入

表明：zbbook
字段：zbSerial（主键,字符型）,name,content,lastTime,state

要求：zbSerial编号规则：ZBYYYYMMDDNNN,'ZB'固定，YYYYMMDD是当前时间，NNN是3位流水号
例如：ZB20090926001，ZB20090926002，ZB20090926003

如何实现？

---

SQL code:
mysql> select concat('ZB',replace(curdate(),'-',''),'001');
+----------------------------------------------+
| concat('ZB',replace(curdate(),'-',''),'001') |
+----------------------------------------------+
| ZB20090926001 |
+----------------------------------------------+
1 row in set (0.00 sec)

---

SQL code:
mysql> select concat('ZB',replace(curdate(),'-',''),id) from test;
+-------------------------------------------+
| concat('ZB',replace(curdate(),'-',''),id) |
+-------------------------------------------+
| ZB20090926001 |
| ZB20090926002 |
| ZB20090926003 |
+-------------------------------------------+
3 rows in set (0.00 sec)

mysql> select * from test;
+-----+
| id |
+-----+
| 001 |
| 002 |
| 003 |
+-----+
3 rows in set (0.00 sec)

---

SQL code

---

Code highlighting produced by Actipr