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 vote201 views1 answer
Django mssql backend
SQL
3 votes229 views2 answers
Check data in table mysql
SQL
0 vote207 views1 answer
Sql tablo hangi sp de
SQL
14 votes210 views3 answers
Inner join sql oracle
SQL
7 votes205 views5 answers
Oracle alter table
SQL
8 votes202 views2 answers
Between operator
SQL
0 vote234 views1 answer
C# sql transaction multiple connections
SQL
0 vote193 views1 answer
SQL Query to delete all the tables in a database
SQL
3 votes201 views2 answers
How to modify rows in SQL Server
SQL
0 vote184 views1 answer
Mysql group rows with same value
SQL