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
dan...@electroteque.org 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 ?
8 messages in com.mysql.lists.mysqlRe: Generating ticket/file numbers
