Error creating MySQL Trigger for Delete

Question

I am using this to prevent any delete from MySQL table user

delimiter //
CREATE TRIGGER tr_no_del BEFORE DELETE on user
FOR EACH ROW SET
BEGIN
    UPDATE user SET a=0;
END;//
delimiter ;

But mysql is giving some syntax error, any ideas what i am missing here?

Thanks!

FOR EACH ROW SET should be FOR EACH ROW instead, as mentioned by @catalinetu. But you should ever include the error message you get, so we know with what problem we're confronted. — VMai
– VMai, Commented Aug 4, 2014 at 18:55

catalinetu · Accepted Answer · 2014-08-04 19:31:04Z

1

try this one

DELIMITER //

DROP TRIGGER IF EXISTS tr_no_del//

CREATE TRIGGER tr_no_del BEFORE DELETE ON `user`
FOR EACH ROW 
BEGIN
    UPDATE USER SET a=0;
END;//
DELIMITER ;

edited Aug 4, 2014 at 19:31

answered Aug 4, 2014 at 18:50

catalinetu

6606 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

user2955412 Over a year ago

error: #1235 - This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

VMai Over a year ago

@user2955412 Well then remove this existing trigger first.

user2955412 Over a year ago

mysql version: 5.1.73-cll - MySQL Community Server (GPLv2)

catalinetu Over a year ago

can you check if there are other triggers?

catalinetu Over a year ago

try with this to view the triggers on user table SHOW TRIGGERS WHERE table = user; and with this to view the events from current database SHOW EVENTS FROM database;

|

Collectives™ on Stack Overflow

Error creating MySQL Trigger for Delete

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related