SET GLOBAL event_scheduler = ON;
delimiter $$
drop event if exists e_wom_stat;
create event e_wom_stat
on schedule
EVERY 1 day
STARTS '2013-01-01 03:00:00'
ON COMPLETION PRESERVE ENABLE
do
begin
delete from t_wom_random_num where time<(CURRENT_TIMESTAMP()+INTERVAL -25 MINUTE);
end $$
delimiter ;
Read More:
- Set the default time to the current value in MySQL
- How to get the current time in java time string
- The shell gets the current time of the system and formats it
- Linux view current date and time
- Shell gets the current time of the system and formats it
- Common shell (1): shell gets the current time stamp of the system
- Perl application – delete “. SVN” folder in current directory and subdirectory
- MySQL:ERROR 1067 (42000): Invalid default value for ‘end_time’
- In SQLite database, set the default value for the field as the current time
- Lua — using remove to delete table data
- Python data cleaning — delete failed images__ Simple version
- MYSQL:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- [MySQL] [serialize] [error record] after modifying data, no data will be returned (in fact, MySQL does not support it)
- Error (1820) if the password is not changed in time after MySQL installation
- MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
- [Solved] Es delete all the data in the index without deleting the index structure, including curl deletion
- MYSQL ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
- The time of the time database displayed by the front end is inconsistent
- MySQL error code 1217 (ER_ROW_IS_REFERENCED): Cannot delete or update a parent row: a foreign key co
- Docker delete error response from daemon: Conflict: unable to delete xxxxx solution