Yeah, this is why some people like the idea of having transaction supports
in the tables, to make sure both the inserts to the two tables succeed, or
none of them do. Currently MyISAM does not support this, only the newly
introduced Berkeley DB tables support this feature although it is assumed
Well, there's a few things. First, I think you need to do a few things to
better normalize your data. You need a table to join a person with a job.
It would look like this:
create table peoplejob (people_id int not null, job_id not null)
Then remove the job column from people.
Then when you
you can't. You have to do 2 seperate inserts. (Sorry)
Cal
http://www.calevans.com
-Original Message-
From: Bryan Wheelock [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 3:47 PM
To: [EMAIL PROTECTED]
Subject: INSERT records into multiple tables
I'm just learning how to use