Advertisement
Guest User

Untitled

a guest
Nov 23rd, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.37 KB | None | 0 0
  1. SET @@global.event_scheduler = 1;
  2.  
  3. DELIMITER //
  4.  
  5. DROP PROCEDURE IF EXISTS update_id //
  6.  
  7. CREATE PROCEDURE update_id()
  8.     BEGIN
  9.         SELECT MAX(id) INTO @var FROM mybb_users WHERE id<5755757;
  10.         UPDATE mybb_users SET id = @var+1 WHERE id = 5755757;
  11.     END //
  12.  
  13. CREATE EVENT update_id_event
  14.     ON SCHEDULE EVERY 5 MINUTE
  15.     DO
  16.       CALL update_id() //
  17.  
  18. DELIMITER ;
  19. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement