INSERT and SELECT at the Same Time?

[Anon]

If I have a table that AUTO INCREMENTS a column everytime I insert a row, is it possible to do a query that does the INSERT and SELECT the incremented value at the same time?

Thanks in advance!

[alcapone]

yeah you could do this trick with last_insert_id() which will show you the last value in auto_increment column

cheers,
AlCapone

P.S. just make sure you don't get the id which was inserted after yours but before the select query 🙂

[[deleted]]

Small note: this function has a different name for each database type in PHP, so you'll have to check the manual for which function you shouold use.

Other small note: The 'last_insert_id' functions work on a connection basis. THat means, you will always get the id that was last inserted over the connection that you are currently using. That means you will never get the id of a record that someone else has just inserted.