Guest User

Untitled

a guest
Jan 11th, 2019
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. BEGIN
  2. SET @statement = CONCAT('CREATE EVENT test_event_',var,'
  3. ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 24 HOUR
  4. DO SELECT * FROM table');
  5. PREPARE stmt FROM @statement;
  6. EXECUTE stmt;
  7. END
  8.  
  9. CALL proc(5);
  10.  
  11. #1295 - This command is not supported in the prepared statement protocol yet
Add Comment
Please, Sign In to add comment