cool so i create a unique field say ticket_number , then when inserting concat it to look like NEW-20040414-01 or NEW-01 u reckon ?
> -----Original Message----- > From: Terence [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 14, 2004 7:29 PM > To: [EMAIL PROTECTED] > Subject: Re: two auto-inc fields possible ? > > > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
