Which of the following is a valid syntax for creating a scheduled event in MySQL?
a. CREATE SCHEDULED EVENT event_name EVERY 1 DAY EXECUTE -- SQL statements to execute
b. CREATE EVENT ON SCHEDULE EVERY 1 DAY BEGIN -- SQL statements to execute END
c. CREATE EVENT event_name ON SCHEDULE EVERY 1 DAY DO BEGIN -- SQL statements to execute END
d. CREATE PROCEDURE event_name ON SCHEDULE EVERY 1 DAY DO BEGIN -- SQL statements to execute END



Answer :

Other Questions