a guest Jan 11th, 2019 52 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- 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;
- CALL proc(5);
- #1295 - This command is not supported in the prepared statement protocol yet
RAW Paste Data