Enabling the MySQL Event Scheduler

By October 11, 2012 August 3rd, 2017 My SQL
MySQL events are executed by a special event scheduler thread. It’s disabled by default. MySQL 5.1 Event Scheduler, Conceptually, this is similar to the idea of the UNIX crontab (also known as a “cron job”)
The MySQL Event Scheduler manages the scheduling and execution of events.

If you are running larg number of data like Shopping Cart, Any Portals that time we need to handle data.

Here is Simple example

Create Table

CREATE TABLE user
(
user_id INT  AUTO_INCREMENT,
user varchar(250),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (user_id)
) ;

Start phpmyadmin

SET GLOBAL event_scheduler = ON;

Creat New Event

CREATE EVENT newEvent
ON SCHEDULE EVERY 1 DAY
DO
DELETE FROM user WHERE created_at = DATE_SUB(NOW(), INTERVAL 10 DAY);

Finished………….. 🙂

Leave a Reply

20 + = 23