Data base error checking

[Anon]

Hi all
If I have a script that uses 3 different queries to add data to 3 different (but related) tables in a db.
What happens if the script gets terminated before all 3 are completed?

Cheers

Nick

[smarlowe]

You use a database that supports transactions, then either they all go or none go.

[jcleary]

quite right. MySQL is fast but at a price. I believe Postgress is V good.