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 vote360 views1 answer
How to get table id sequence postgres
SQL
0 vote343 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote331 views1 answer
Sql character index
SQL
0 vote337 views1 answer
My sql data file extention
SQL
0 vote339 views1 answer
Full outer join in mariadb mysql
SQL
0 vote334 views1 answer
Postgres clear table
SQL
0 vote339 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote338 views1 answer
Get who is hired in february in sql
SQL
11 votes325 views4 answers
Query DISTINCT
SQL
0 vote333 views1 answer
Connect to nginx server mysql remotly
SQL