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 vote106 views1 answer
Cannot start database server xampp mac os
SQL
0 vote105 views2 answers
T SQl Checking Your Username
SQL
1 vote49 views1 answer
File /etc/init.d/mysql not exists
SQL
3 votes128 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
5 votes98 views4 answers
Describe table postgres
SQL
0 vote110 views1 answer
Mysql update even / odd rows
SQL
3 votes98 views1 answer
APEX elapsed time
SQL
0 vote93 views1 answer
Mysql last 6 months
SQL
11 votes108 views2 answers
Insert current date sql
SQL
0 vote97 views1 answer
Android sqlite get rows count
SQL