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 vote341 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote338 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
2 votes315 views1 answer
Select * from table where name like
SQL
1 vote340 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote321 views1 answer
Mysql filter based on datediff
SQL
1 vote327 views1 answer
Oracle create as select
SQL
0 vote336 views1 answer
Duplix print in Smartforms
SQL
10 votes306 views3 answers
Sql limit results
SQL
0 vote399 views1 answer
Postgres extract number from string
SQL
0 vote323 views1 answer
Install squirrel sql ubuntu
SQL