Collecting the primary key using MAX during an insert

[Dan Rossi]

Hi there, I was wondering how its possible to get the MAX of a primary 
key of a table during an insert. I basically want to create a ticket 
number, but use the primary key as part of the ticket number ie 
FAULT-0000001 or FAULT-00000002 . I tried during a sub query on an 
insert but obviouslly not working :|

Let me know.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]