How to Insert Child Record??

[amy.damnit]

Hi all. Say, I'm very rusty on my DML.

I have a 1-to-M relationship and need to INSERT a record into the Child Table and point it back to the Parent table.

How do I do that with SQL and since it requires two queries - presumably - do I need a Transaction??

Thanks,


Amy

[r937]

it requires only one query -- the INSERT statement

you will already know which parent the child belongs to, yes?

[amy.damnit]

it requires only one query -- the INSERT statement

you will already know which parent the child belongs to, yes?

See, I told you I was rusty!! (Plus I posted that on 3 1/2 hours sleep!)

You are correct, I guess it isn't that difficult.

Thanks,


Amy

[amy.damnit]

I take back what I said the other day...

This is as tricky as I originally thought!

I would like to know how to INSERT both a Parent and a Child record at the same time and be certain that the new Primary Key (i.e. AutoIncrement) and the Foreign Key (Int) match up and that there aren't any conflicts between other users or records?!

I assume this should be done in a transaction...

I am Googling "Last_Insert_ID" but could use some help here!

Thanks,


Amy

[r937]

1. run INSERT for parent row
2. use LAST_INSERT_ID to pick up the auto_increment value
3. run INSERT for child row