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]