get id in trigger before delete
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
Subject
Views
Written By
Posted
get id in trigger before delete
3085
June 13, 2014 06:07PM
1346
June 13, 2014 09:35PM
1368
June 13, 2014 09:55PM
1171
June 19, 2014 08:11AM
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.