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 vote313 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote288 views1 answer
Add SuperUser MySQL
SQL
1 vote301 views1 answer
Spring postgresql reset auto increment to 0
SQL
39 votes350 views5 answers
Sql drop column
SQL
8 votes308 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
1 vote290 views2 answers
Sql drop multiple columns if exists
SQL
0 vote314 views1 answer
Sql filter rows with condition
SQL
4 votes300 views1 answer
Wildcard in sql
SQL
6 votes304 views3 answers
Commit in sql
SQL
1 vote301 views1 answer
Tsql get beginning of year
SQL