CODEWITHSUNDEEP
mysqlsql
Dark Shadow
Dark Shadow

Reputation: 35

Updating after delete | mysql trigger

I have two tables for example table1 and table2. If something is deleted in table1 i want to update a column in table2. Is this even possible with a trigger in phpmyadmin? if yes what do i have to add or which syntax i have to use for it to work?

I tried this so far:

DELIMITER //
CREATE TRIGGER `update` AFTER DELETE ON table1
FOR EACH ROW BEGIN
-- this is the part i dont know what to do and i couldnt find any related to my task

END//
DELIMITER ;

Upvotes: 0

Views: 2339

Answers (1)

Mickaël Leger
Mickaël Leger

Reputation: 3440

Well, in your TRIGGER you can access the value you just deleted with OLD.your_column_name.

So just do :

DELIMITER //
CREATE TRIGGER `update` AFTER DELETE ON table1
FOR EACH ROW BEGIN

UPDATE table2 SET column_name = your_new_value WHERE column_name = OLD.old_value;

END//
DELIMITER ;

Upvotes: 3

Related Questions