I'm working on a customer service system which return a customer a ticket number after placing a request. A ticket number is an id in request table, like:
table request
id number
request
string subject string
customer_id number
I use insert like:
I'd like to know ticket id after insertion. Will it be reliable in multi requests environment if I use for getting id under the same transaction the following query:
Is there any more elegant way to do that?