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

1 vote150 views1 answer
Mysql select utc time in eastern time
SQL
-2 votes147 views1 answer
How to open database
SQL
22 votes182 views1 answer
Mysql workbench
SQL
0 vote138 views1 answer
Limiting query result using where in sql
SQL
0 vote155 views2 answers
Plsql function that return a table
SQL
0 vote143 views1 answer
Mysql convert charset
SQL
-2 votes152 views2 answers
Sqlserver docker
SQL
7 votes142 views3 answers
Sql update where id
SQL
0 vote149 views1 answer
Sql server alter table add column tinyint
SQL
0 vote153 views1 answer
Mysql make date from 2 column
SQL