I am using a mysql table with a field rec_id which is set to auto increment. I need the value of rec_id after I insert a new record. Is there a way to do this without actually doing a select statement after the insert.
i.e. is there a way to get the value of rec_id directly from the insert.
i.e. is there a way to get the value of rec_id directly from the insert.