Daniel,
It's really not clear to me exactly what you want. For example, what do you mean by file numbers? Perhaps if you could tell us a little more about your table, your query, and the result you want, we could provide a solution.
Michael
[EMAIL PROTECTED] wrote:
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]