Insert And Fetch

[Mushroom]

Are there any way to get some field of the row which I have just inserted into database WITH ONLY ONE QUERY?

[the_Igel]

[man]mysql_insert_id()[/man]

[terrabull]

You could also somehow include:
select LAST_INSERT_ID();
in a sql query, so you'll only end up with one query,
but I'm not sure how the sql would go...

🙁

(I assume you are using mysql.)

The way to do it in postgres is different.