MySQL Forums
Forum List  »  Triggers

get id in trigger before delete
Posted by: Ankur Kaushik
Date: June 13, 2014 06:07PM

I have table
mysql> select * from dtrigger;
+----+------+
| id | name |
+----+------+
| 1 | qwe |
| 2 | asd |
| 3 | zxc |
| 4 | qaz |
| 5 | wsx |
| 6 | edc |
+----+------+

I want to create trigger as if

delete from dtrigger where name='qwe' then corresponding
id goes to other table before deletion

Options: ReplyQuote


Subject
Views
Written By
Posted
get id in trigger before delete
2880
June 13, 2014 06:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.