insert (update) several tables simultaneously?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
wvoyance
Forum Contributor
Posts: 135
Joined: Tue Apr 17, 2012 8:24 pm

insert (update) several tables simultaneously?

Post by wvoyance »

I have 3 tables, and is going to insert one new record.
The first table might be succeeded, but the second or the third one failed.
That will cause problem, for half done.
I want either all succeeded or none.

How can I do that, except by writing a complicate program to check before insertion?

The same question for update.
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: insert (update) several tables simultaneously?

Post by requinix »

Post Reply