> 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.
>
File number = Job Number , or Ticket Number.
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 w
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
___
> 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-01 then AUD-02
>>AUD-00010 etc ... Let me know.
> You can get the 01, etc via something like SeqItem int(6) unsigned
> zerofill auto_i
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-01 then AUD-02 AUD-00010
etc ... Let me know.
You can get the 01, etc via something like SeqItem int(6) unsigned
zerofill auto_increment. T
I already use the autoinc or sequence number as part of the number like
AUD-05--1 where 1 is the record id, just wanted to know if it could
happen on the mysql end.
> [EMAIL PROTECTED] wrote:
>
>>Hi there is there any way at all that with a special field type mysql
>>can generate file number
[EMAIL PROTECTED] wrote:
Hi there is there any way at all that with a special field type mysql can
generate file numbers like so AUD-01 then AUD-02 AUD-00010
etc ... Let me know.
Use an auto_increment field, say an 'unsigned integer auto_increment
primary key'.
Then do the formatti
