14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
m
→before delete trigger to make backup of deleted data
(add before delete trigger to make backup of deleted data) |
|||
| Line 32: | Line 32: | ||
[http://forums.mysql.com/read.php?99,88841,88856#msg-88856 MySQL :: Re: before delete trigger to make backup of deleted data] | [http://forums.mysql.com/read.php?99,88841,88856#msg-88856 MySQL :: Re: before delete trigger to make backup of deleted data] | ||
step 1: create table hello_deleted_data with the same structure of table hello | |||
step 2: add a trigger | |||
<pre> | <pre> | ||
create trigger hello before delete on hello | create trigger hello before delete on hello | ||