Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN
- SET @statement = CONCAT('CREATE EVENT test_event_',var,'
- ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 24 HOUR
- DO SELECT * FROM table');
- PREPARE stmt FROM @statement;
- EXECUTE stmt;
- END
- CALL proc(5);
- #1295 - This command is not supported in the prepared statement protocol yet
Add Comment
Please, Sign In to add comment