mysql trigger to delete old data

Solutions on MaxInterview for mysql trigger to delete old data by the best coders in the world

Search
showing results for - "mysql trigger to delete old data"
Adriana
11 Feb 2017
1SET GLdelimiter //
2create event if not exists clean_old_records
3on schedule every 1 week
4do
5begin
6 delete from your_table_name 
7 where 
8 Timestamp < date_sub(curdate(),interval 1 month) ;
9end; //
10delimiter ;OBAL event_scheduler = ON;
11
source
similar questions
delete row mysqlmysql deletemysql update all record removing 2 hours from columnmysql desactivar triggermysql delete last rowstored procedure to delete data from table in mysqlcreate delete procedure mysqlforcefully delete a row in mysql which has referencescan we rollback data that are deleted using delete clause 3fmysql cannot delete or update a parent rowmysql deletemysql delete entire row on conditionmysql undo deletemysql disable triggershow to delete all the rows in a table without deleting the table in mysqldelete all rows from table mysqldelete all content in table mysqlmysql on delete set nullmysql drop vs deleteupdate 2fdelet in mssqlcan we rollback deleted data in sqldelete row by id mysqlmysql delete rowsmysql on deletemysql drop triggermysql delete row
queries leading to this page
mysql remove triggermysql trigger on delete old valuestrigger for delete mysqldelete trigger mysqldelete trigger in mysqltrigger after delete mysql oldmysql trigger after delete old idtrigger for delete in mysqlmysql trigger after delete get old value to insertdelete trigger in mysql serverhow to delete trigger mysqlmysql function that delete old rowsmysql trigger after delete oldmysql automatically delete old datamysql trigger to delete old datatrigger delete mysqlmysql delete old datamysql trigger to delete old data