|Subject:||Any SQL experts here?|
|Posted by:||SpaceGirl (firstname.lastname@example.org)|
|Date:||Tue, 5 Feb 2008|
Quick SQL question:
Table A contains articles
Table B contains images that belong to articles
Inserting a new record (article) into table A, which has an
incrementing primary key. Several entries also need to be made in
table B, containing the images that belong to the article in table A.
How do I get the key value from A and put it in B at the same time as
Platform: mySQL 5.