How do I get the ID generated?

#1

If I add a row to a table that has an auto incremented ID that is a
foreign key in another table...
How do I get that ID from the last insert statement I generated?

#2

On 1/28/2011 6:57 PM, SpreadTooThin wrote:

Quote:

If I add a row to a table that has an auto incremented ID that is a
foreign key in another table...
How do I get that ID from the last insert statement I generated?

http://www.lmgtfy.com/?q=mysql+insert+id

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#3

On Jan 28, 5:19*pm, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote:

Quote:

On 1/28/2011 6:57 PM, SpreadTooThin wrote:

If I add a row to a table that has an auto incremented ID that is a
foreign key in another table...
How do I get that ID from the last insert statement I generated?

http://www.lmgtfy.com/?q=mysql+insert+id

lol.. You suck.

Quote:

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck... (AT) attglobal (DOT) net
==================

#4

On 1/28/2011 8:13 PM, SpreadTooThin wrote:

Quote:

On Jan 28, 5:19 pm, Jerry Stuckle<jstuck... (AT) attglobal (DOT) net> wrote:
On 1/28/2011 6:57 PM, SpreadTooThin wrote:

If I add a row to a table that has an auto incremented ID that is a
foreign key in another table...
How do I get that ID from the last insert statement I generated?

http://www.lmgtfy.com/?q=mysql+insert+id

lol.. You suck.

Then try googling your own answers next time. Or if you're too lazy,
pay a consultant to answer your questions for you.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#5

On Fri, 28 Jan 2011 15:57:25 -0800 (PST), SpreadTooThin wrote:

Quote:

If I add a row to a table that has an auto incremented ID that is a
foreign key in another table...
How do I get that ID from the last insert statement I generated?

We already covered that yesterday, if you read back in your own prior
thread.

--
53. If the beautiful princess that I capture says "I'll never marry
you! Never, do you hear me, NEVER!!!", I will say "Oh well" and
kill her.
--Peter Anspach's list of things to do as an Evil Overlord

#6

On Jan 28, 7:31*pm, "Peter H. Coffin" <hell... (AT) ninehells (DOT) com> wrote:

Quote:

On Fri, 28 Jan 2011 15:57:25 -0800 (PST), SpreadTooThin wrote:
If I add a row to a table that has an auto incremented ID that is a
foreign key in another table...
How do I get that ID from the last insert statement I generated?

We already covered that yesterday, if you read back in your own prior
thread.

--
53. If the beautiful princess that I capture says "I'll never marry
* * you! Never, do you hear me, NEVER!!!", I will say "Oh well" and
* * kill her.
* * * * --Peter Anspach's list of things to do as an Evil Overlord

Thanks I found it:
http://dev.mysql.com/doc/refman/5.0/...unique-id.html

#7

On Jan 28, 6:33*pm, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote:

Quote:

On 1/28/2011 8:13 PM, SpreadTooThin wrote:

On Jan 28, 5:19 pm, Jerry Stuckle<jstuck... (AT) attglobal (DOT) net> *wrote:
On 1/28/2011 6:57 PM, SpreadTooThin wrote:

If I add a row to a table that has an auto incremented ID that is a
foreign key in another table...
How do I get that ID from the last insert statement I generated?

http://www.lmgtfy.com/?q=mysql+insert+id

lol.. You suck.

Then try googling your own answers next time. *Or if you're too lazy,
pay a consultant to answer your questions for you.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck... (AT) attglobal (DOT) net
==================

Thanks for the help Jerry...
http://www.velocityreviews.com/forum...y-stuckle.html

#8

On Jan 29, 8:23*am, SpreadTooThin <bjobrie... (AT) gmail (DOT) com> wrote:

Quote:

On Jan 28, 7:31*pm, "Peter H. Coffin" <hell... (AT) ninehells (DOT) com> wrote:

On Fri, 28 Jan 2011 15:57:25 -0800 (PST), SpreadTooThin wrote:
If I add a row to a table that has an auto incremented ID that is a
foreign key in another table...
How do I get that ID from the last insert statement I generated?

We already covered that yesterday, if you read back in your own prior
thread.

--
53. If the beautiful princess that I capture says "I'll never marry
* * you! Never, do you hear me, NEVER!!!", I will say "Oh well" and
* * kill her.
* * * * --Peter Anspach's list of things to do as an Evil Overlord

Thanks I found it:http://dev.mysql.com/doc/refman/5.0/...unique-id.html

I'm not sure that this will work in my environment... Which is
REALBasic.
I know this is the comp.database.mysql news group, but is this a SQL
neutral statement?

#9

On 29-01-11 16:41, SpreadTooThin wrote:

Quote:

On Jan 28, 6:33 pm, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote:
On 1/28/2011 8:13 PM, SpreadTooThin wrote:

On Jan 28, 5:19 pm, Jerry Stuckle<jstuck... (AT) attglobal (DOT) net> wrote:
On 1/28/2011 6:57 PM, SpreadTooThin wrote:

If I add a row to a table that has an auto incremented ID that is a
foreign key in another table...
How do I get that ID from the last insert statement I generated?

http://www.lmgtfy.com/?q=mysql+insert+id

lol.. You suck.

Then try googling your own answers next time. Or if you're too lazy,
pay a consultant to answer your questions for you.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck... (AT) attglobal (DOT) net
==================

Thanks for the help Jerry...
http://www.velocityreviews.com/forum...y-stuckle.html

You should not tease Jerry, his company does exist...
http://www.manta.com/c/mmd74gb/jds-c...-training-corp
(if its the company mentioned at that link)

--
Luuk

#10

On Sat, 29 Jan 2011 07:42:30 -0800 (PST), SpreadTooThin wrote:

Quote:

I'm not sure that this will work in my environment... Which is
REALBasic.
I know this is the comp.database.mysql news group, but is this a SQL
neutral statement?

It's a mysql-only statement, but the sql version (the non-api version)
is application-neutral, and even works if you're using the CLI and
Expect or something. Many other RDBMSs have their own mechanism to
accomplish the same thing though.

--
When all you have is a hammer, every problem looks like a messiah.