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
3296
June 13, 2014 06:07PM
1448
June 13, 2014 09:35PM
1477
June 13, 2014 09:55PM
1256
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.