Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @@global.event_scheduler = 1;
- DELIMITER //
- DROP PROCEDURE IF EXISTS update_id //
- CREATE PROCEDURE update_id()
- BEGIN
- SELECT MAX(id) INTO @var FROM mybb_users WHERE id<5755757;
- UPDATE mybb_users SET id = @var+1 WHERE id = 5755757;
- END //
- CREATE EVENT update_id_event
- ON SCHEDULE EVERY 5 MINUTE
- DO
- CALL update_id() //
- DELIMITER ;
- COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement