nope i don't think it's possible
BUT you can use the concat feature to get the result:
select concat('NEW-',running_id), concat('DEP-',running_id')
so long as your running numbers are the same...we use this for our helpdesk
system too :)
good luck.
----- Original Message -----
From: "electroteque" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 14, 2004 5:11 PM
Subject: two auto-inc fields possible ?
Hi there i was wondering if its possible to have two auto-inc fields ? I am
having to generate ticket numbers and i want it to look like DEP-00001,
DEP-00002, NEW-00001, NEW-000002 where NEW and DEP are the first 3 letters
of of the department associated with the ticket. How is this possible ? I've
noticed postgres has the serial data type is there an equiv in mysql ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
