Re: How to alter a trigger atomicly?

[Sebastian Kirsche]

Temporarily renaming the table appears to work. Changes to mytable from other threads will fail.


DELIMITER $$
ALTER TABLE `mytable` RENAME TO `mytable_locked` $$
DROP TRIGGER IF EXISTS `mytable_ait` $$
CREATE TRIGGER `mytable_ait` AFTER INSERT ON `mytable_locked`
FOR EACH ROW
BEGIN
...
END $$
ALTER TABLE `mytable_locked` RENAME TO `mytable` $$
DELIMITER ;