@jonb2.. We checked with HeidiSQL. Yes, they do allow to edit and save trigger. But..on SAVE they execute these queries(Checked from their query LOG)-
Code:
DROP TRIGGER `customer_create_date`;
/* 0 rows affected. */
CREATE DEFINER=`root`@`localhost` TRIGGER `customer_create_date` BEFORE INSERT ON `customer` FOR EACH ROW SET NEW.create_date = NOW();
Now, with SQLyog when you do Execute All these queries are executed-
Code:
DROP TRIGGER /*!50032 IF EXISTS */ `customer_create_date`;
CREATE ;
Priority fix, of course!