Any SQL experts here?

Giganews Newsgroups
Subject: Any SQL experts here?
Posted by:  SpaceGirl (nothespacegirlspam@subhuman.net)
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
inserting A.

Platform: mySQL 5.

Me... stuck.

Replies