> 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.
maybe a table to autogenerate the file numbers ? maybe thats a waste of time and resource ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]