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? | hardc0d3r | 24 Aug |
• Re: what if i need the primary key of a row that is to be inserted? | Martijn Tonies | 24 Aug |
• Re: what if i need the primary key of a row that is to be inserted? | hardc0d3r | 24 Aug |
• Re: what if i need the primary key of a row that is to be inserted? | Michael Dykman | 24 Aug |
• Re: what if i need the primary key of a row that is to be inserted? | Rudy Lippan | 24 Aug |
• Re: what if i need the primary key of a row that is to be inserted? | Martijn Tonies | 24 Aug |