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 vote296 views1 answer
Get initials name in sql
SQL
13 votes289 views2 answers
Sql join 3 tables
SQL
0 vote283 views1 answer
Sql convert float to string
SQL
20 votes277 views4 answers
Sqlite create table if not exists
SQL
16 votes354 views2 answers
Sql vs nosql
SQL
-2 votes269 views1 answer
Mysql not empty
SQL
4 votes275 views3 answers
How to describe a table in sqlite3
SQL
5 votes276 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote270 views1 answer
How to access to mysql without root
SQL
0 vote271 views1 answer
Order by with where clause in mysql
SQL