I'm assuming you have AUTO_INCREMENT columns in each table? Try this:
INSERT INTO TABLE1(...) VALUES(...); SELECT @t1id := LAST_INSERT_ID(); INSERT INTO TABLE1A(table1_id, ...) VALUES(@t1id, ....); INSERT INTO TABLE1B(table1_id, ...) VALUES(@t1id, ....); ... -JF > -----Original Message----- > From: Aamer Rauf [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 24, 2002 12:55 PM > To: [EMAIL PROTECTED] > Subject: Primary and Foreign Keys in MySQL > > > Hello, > > I am working on MySQL database. I have come across a 'problem' > but don't know > how to get around that. The problem is the following: > I have a table, say TABLE1, with primary key being called as table1_id. > Now there are other tables, like TABLE1A, TABLE1B, TABLE1C etc.. > where I want to > use primary key of TABLE1 (i.e table1_id) as foreign key. I see a > problem in > using the function LAST_INSERT_ID(). Lets say I use it to insert > a record in > TABLE1A, that will work fine. But now if I use it to put a record > in TABLE1B it > would give me the primary key ID of TABLE1A rather than TABLE1. > Please help me > out on this. > > Aamer > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
