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 vote163 views1 answer
Delet all record statment sql
SQL
0 vote120 views1 answer
Sql count more than 1
SQL
3 votes115 views1 answer
Select table column in sql
SQL
0 vote106 views1 answer
Mysql replication change database name
SQL
0 vote139 views1 answer
Mysql collation portugues brasil
SQL
-1 vote109 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote155 views1 answer
Kimball data warehouse sql calendar
SQL
1 vote117 views1 answer
Tsql find foreign key references
SQL
0 vote137 views1 answer
Traccar mysql
SQL
1 vote115 views1 answer
Where date = max(date) in sql
SQL