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 vote135 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote113 views1 answer
Sql gather statistics to increase performance
SQL
2 votes118 views1 answer
Sql server conection string
SQL
0 vote129 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
0 vote120 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
12 votes119 views1 answer
Docker mysql random root password
SQL
14 votes118 views3 answers
SQL trim
SQL
0 vote127 views1 answer
How to access to mysql without root
SQL
0 vote136 views1 answer
MySQL get all previous date record
SQL
0 vote124 views1 answer
Mysql pv progres
SQL