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

4 votes196 views3 answers
Is not null sql
SQL
8 votes176 views1 answer
How to remove tables from postgresql
SQL
0 vote233 views1 answer
Table structure in sql
SQL
0 vote239 views1 answer
Python mysql executemany
SQL
0 vote188 views1 answer
Declare or use variable in snowflake
SQL
0 vote251 views1 answer
How do you insert boolean to postgresql
SQL
0 vote199 views1 answer
What is top n result in sql
SQL
0 vote178 views2 answers
Sql day from datetime
SQL
0 vote177 views1 answer
IIF
SQL
1 vote181 views3 answers
Execute sp in sql server
SQL