I think you have a simple syntax error, you are using a database
. tablename
as the name of this Event, instead use a arbitrary name for your event.
delimiter :
CREATE EVENT IF NOT EXISTS tidy_session_table
ON SCHEDULE EVERY 3 DAY
COMMENT 'Auto Delete Old Session Records'
DO
BEGIN
DELETE FROM `dbname`.`table` WHERE `Created_Date` < CURRENT_TIMESTAMP;
END
delimiter ;
2
solved session variables are not persisting in php in another page [closed]