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 vote311 views1 answer
How to subquey to do not load in live database in
SQL
10 votes251 views4 answers
Mysql one week ago
SQL
0 vote263 views1 answer
Postgresql in vs any performance
SQL
0 vote254 views1 answer
How to stop all connections to a psql 12 database?
SQL
5 votes278 views1 answer
How to get all table names in sql query
SQL
0 vote230 views1 answer
Postgres get running query
SQL
0 vote258 views1 answer
Mysql conf.d exampel
SQL
1 vote263 views1 answer
Sql drop schema
SQL
14 votes304 views6 answers
Finding duplicate rows mysql
SQL
0 vote263 views1 answer
Sql count matching group by
SQL