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

0 vote212 views1 answer
Create a table from one field of another table
SQL
0 vote216 views1 answer
How do you insert boolean to postgresql
SQL
0 vote187 views1 answer
Sql right characters
SQL
5 votes218 views1 answer
How to get all dates in a month in oracle
SQL
0 vote224 views1 answer
Mysql convert charset
SQL
6 votes162 views2 answers
Generate c# class from sql server table
SQL
0 vote204 views1 answer
Create relationship with betwen two tables in postgersql
SQL
2 votes225 views3 answers
Sql interview query questions
SQL
50 votes226 views6 answers
Install mysql on ubuntu
SQL
8 votes221 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL