List:General Discussion« Previous MessageNext Message »
From:hardc0d3r Date:August 24 2007 2:25pm
Subject:what if i need the primary key of a row that is to be inserted?
View as plain text  
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.

Thread
what if i need the primary key of a row that is to be inserted?hardc0d3r24 Aug
  • Re: what if i need the primary key of a row that is to be inserted?Martijn Tonies24 Aug
    • Re: what if i need the primary key of a row that is to be inserted?hardc0d3r24 Aug
      • Re: what if i need the primary key of a row that is to be inserted?Michael Dykman24 Aug
        • Re: what if i need the primary key of a row that is to be inserted?Rudy Lippan24 Aug
  • Re: what if i need the primary key of a row that is to be inserted?Martijn Tonies24 Aug