> 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
.html
Eamon Daly
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Wednesday, February 16, 2005 3:35 PM
Subject: Generating ticket/file numbers
Hi there is there any way at all that with a special field type mysql can
generate file numbers like so AUD-
> 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
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
