Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    24

    Unanswered: mysql enterprise and trigger

    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.

  2. #2
    Join Date
    Feb 2008
    Location
    Bandung - Indonesia
    Posts
    15
    Bug #10946 Confusing error messeges in the case of duplicate trigger definition

    http://bugs.mysql.com/bug.php?id=10946

    Bug #35779 'Trigger already exists' error + renamed table

    http://bugs.mysql.com/bug.php?id=35779
    Forum Informatika - Indonesian Informatics Online Community - http://if.web.id

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •