Mysql trigger to delete old data

SET GLdelimiter //
create event if not exists clean_old_records
on schedule every 1 week
do
begin
 delete from your_table_name 
 where 
 Timestamp < date_sub(curdate(),interval 1 month) ;
end; //
delimiter ;OBAL event_scheduler = ON;

Source: stackoverflow.com

Similar codes

1 vote211 views1 answer
Oracle add proxy
SQL
23 votes224 views1 answer
How remove column in mysql
SQL
0 vote230 views1 answer
Add a new column into table
SQL
19 votes221 views6 answers
Sql server drop table if exists
SQL
0 vote210 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
3 votes224 views1 answer
Postgres kill running query
SQL
0 vote225 views1 answer
Oracle cpu metric
SQL
0 vote224 views1 answer
Oracle list datafiles
SQL
0 vote225 views1 answer
Oracle for loop on list
SQL
1 vote203 views1 answer
Select statement to print longest name
SQL