You probably want a multiple column sequence. See pages 562 through 567 of the MySQL Cookbook by Paul DuBois, 1st. ed. for an excellent and thorough description.
It's also briefly mentioned at:
http://dev.mysql.com/doc/mysql/en/example-auto-increment.html
____________________________________________________________ Eamon Daly
----- Original Message ----- From: <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Wednesday, February 16, 2005 3:35 PM
Subject: Generating ticket/file numbers
Hi there is there any way at all that with a special field type mysql can generate file numbers like so AUD-000001 then AUD-000002 .... AUD-00010 etc ... Let me know.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
