PHP and MySQL syntax: Difference between revisions

Jump to navigation Jump to search
m
(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]


action1. create table hello_deleted_data with the same structure of table hello
step 1: create table hello_deleted_data with the same structure of table hello


action2. add a trigger
step 2: add a trigger
<pre>
<pre>
create trigger hello before delete on hello  
create trigger hello before delete on hello  

Navigation menu