[GENERAL] Disable triggers per transaction 8.2.3

[Henrik]

Hello list,

I wonder if it is possible to disable triggers for a single transaction.
I know I can disable triggers per table but then I need to disable  
all triggers in all recursive tables before doing by query.

Can I do:
BEGIN TRANSACTION;
DISABLE TRIGGERS;
DELETE FROM tbl_foo WHERE ID > 5;
ENABLE TRIGGERS;
COMMIT;

Or do I have to do:
BEGIN TRANSACTION;
ALTER TABLE tbl_foo DISABLE TRIGGERS ALL;
ALTER TABLE tbl_foo_bar DISABLE TRIGGERS ALL;

DELETE FROM tbl_foo WHERE ID > 5;

ALTER TABLE tbl_foo ENABLE TRIGGERS ALL;
ALTER TABLE tbl_foo_bar ENABLE TRIGGERS ALL;

COMMIT;

Or is it even possible? I only want my triggers to be disabled for  
the transaction and not the global database.

Thanks,
Henke


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings