My Table is
create table dtrigger (id int not null primary key auto_increment,name varchar(64));


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