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

15 votes146 views2 answers
How to know the username of postgresql
SQL
1 vote139 views1 answer
Mysql connect bash
SQL
2 votes127 views1 answer
Oracle sql drop table purge
SQL
0 vote196 views2 answers
Mysql cast to varchar
SQL
0 vote103 views1 answer
Connection error in mysql workbench
SQL
5 votes130 views1 answer
Oracle get nls settings
SQL
15 votes150 views4 answers
Pl sql
SQL
0 vote230 views1 answer
Sql insert exemplo
SQL
0 vote142 views1 answer
Datatables server side filter where clause
SQL
2 votes204 views1 answer
Oracle run_duration to number
SQL