At 04:35 pm 2/16/2005, you wrote:
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.
You can get the 000001, etc via something like SeqItem int(6) unsigned
zerofill auto_increment. Then select "AUD_", SeqItem from the table.
However, only one field can be auto_increment.
Eldon Ziegler
MySQL Database Systems and Support
www.atlanticdb.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]