unfortunetly in work i have to use mysql 5.0.77.
till some compilation of heidi everythings worked fine, but in the latest i've got this error.
/ Błąd SQL (1064) w instrukcji #67: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER db_name
.some_trigger_name
;SHOW CREATE TABLE db_name
.`some_table_name' at line 1 /
i'm guesing that problem is in showing trigger body becouse SHOW CREATE TRIGGER is not supported in this MySQL version.
in earlier version, heidi where using: SHOW TRIGGERS FROM db_name
;
It would be nice if you could FIX it
Best regards