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 vote348 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote367 views1 answer
Sqlalchemy get schema from database
SQL
1 vote382 views1 answer
Table valued functions in sql
SQL
0 vote365 views1 answer
Create database like
SQL
0 vote340 views1 answer
Get first monday of month sql
SQL
0 vote352 views1 answer
Get cpu details sql
SQL
0 vote417 views3 answers
Constraint sql
SQL
9 votes363 views2 answers
Sql limit to 5 results
SQL
0 vote346 views2 answers
Postgresql get last day of month
SQL
1 vote363 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL