transactions

Hi, I was reading mysql's manual, about transactions and all... and I didn't find what they said about 'atomic operations' being as safe as transactions. I couldn't figure out HOW to update 5 tables at a time ENSURING that ALL will be update or NONE. How can this be done without transactions? With code? I don't think so... can anyone clear my mind here... I have this problem... I need to update 4 tables at once, and if something goes wrong I have to UNDO everything.... ____________________________ . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer