what if i need the primary key of a row that is to be inserted?

[hardc0d3r]

what if i need the primary key of a row that is to be inserted? that primary
key will be used to insert another row from another table.. what i was doing
was after inserting the row, i get the primary key by select statement and
use that value to insert a row from another table.. is this ok? are there
any more efficient ways of doing this?
-- 
View this message in context:
http://www.nabble.com/what-if-i-need-the-primary-key-of-a-row-that-is-to-be-inserted--tf4323900.html#a12313472
Sent from the MySQL - General mailing list archive at Nabble.com.