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

3 votes125 views2 answers
Mysql update row
SQL
4 votes118 views1 answer
Psql get sequences
SQL
10 votes127 views2 answers
Sql pagination offset
SQL
14 votes131 views2 answers
Install mysqldump
SQL
2 votes136 views2 answers
Mysql add hours to time field
SQL
0 vote134 views1 answer
Changing name of column and datatype in sql
SQL
0 vote142 views1 answer
Snowflake drop column
SQL
-1 vote148 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote130 views1 answer
Sql search all columns of database oracle sql
SQL
8 votes91 views1 answer
Similarities between ddl and dml
SQL