在删除行之前选择字段值

Question

The following are my table fields:

pk_stu_sub_id | fk_stu_class_id | fk_class_sub_id | fk_user_id | timestamp

What I need to do is delete the row when pk_stu_sub_id = (variable) but get the value of fk_stu_class_id before deleting it. I need to write PHP code for this.

Is it possible to do this? If so, then how?

Answer 1

you can create a trigger on your table that when delete each row, trigger will fire and save fk_stu_class_id in another table For more about triggers see: http://dev.mysql.com/doc/refman/5.1/en/triggers.html