mysql error 1360, cannot drop trigger. is this a bug?

delimiter $$

CREATE TRIGGER carslibrary_trigger
    AFTER insert ON carslibrary
    FOR EACH ROW
    BEGIN
      insert into facerecord (carslibrary_ID) values (new.CarID);
END$$

delimiter;

i am trying to delete my trigger

Showing rows 0 - 0 (1 total, Query took 0.0087 sec)
SELECT trigger_name
FROM information_schema.triggers
WHERE event_object_table =  'carslibrary'
AND ac开发者_JAVA百科tion_timing =  'AFTER'
AND event_manipulation =  'INSERT'
LIMIT 0 , 30

drop trigger carslibrary_trigger;

#1360 - Trigger does not exist
DROP trigger carslibrary_trigger;

my query returned a record, but it can't drop?

why i can't drop my trigger?

i also made a general query still returns 1 record

Showing rows 0 - 0 (1 total, Query took 0.0606 sec) SELECT * FROM TRIGGERS LIMIT 0 , 30

What version of MySQL? You may have to include table name.

DROP TRIGGER carslibrary.carslibrary_trigger;

If anyone get this issue using MyISAM engine, check the TRN files in the data folder, in my case those were there, even though I deleted the trigger using command line.

Manually Deleting TRN files of the triggers that are throwing error 1360 will solve the issue.

if the error trigger does not exist with error code 1360 occurs, simply execute the triggers from command line

mysql -u root -p then mysql> execute the triggers

then check the information_schema in mysql

the triggers can be viewed there

just edit table data