Dear all,
i am using mysql 5.0 enterprise. recently i added trigger to a table and copied whole db to another system. but the trigger is not working. when i try to create the
trigger, query finishes with error "trigger already exists" when i delete it displays " trigger doesn't exists"
Code:
mysql> drop trigger my_STime;
ERROR 1360 (HY000): Trigger does not exist
mysql> DELIMITER |
mysql>
mysql> CREATE TRIGGER my_STime
-> BEFORE INSERT ON EMP
-> FOR EACH ROW
-> BEGIN
-> SET NEW.SStDate = FROM_UNIXTIME(NEW.StartTime);
-> SET NEW.SDTime = FROM_UNIXTIME(NEW.StartTime);
-> END;
-> |
ERROR 1359 (HY000): Trigger already exists
mysql>
can any one help me on this, i can create another trigger
thanks.
dBforums
>
mysql enterprise and trigger
01-03-09, 21:36
Linear Mode
