Computer scienceSoftware development foundationsSQL and databasesDBMSMySQLMySQL syntax

IF statement

Correct construction

Report a typo

There is an event_list table. Choose the correct IF ElSE block for the procedure.

Select one option from the list

IF true THEN
INSERT INTO event_list (action) VALUES ('take red hat');
ELSE
INSERT INTO event_list (action) VALUES ('buy ice cream');
END IF;

IF true
INSERT INTO event_list (action) VALUES ('take glasses');
IF true
INSERT INTO event_list (action) VALUES ('take book');
END IF;

IF true THEN
NSERT INTO event_list (action) VALUES ('take sunscreen');
ELSE true THEN
INSERT INTOevent_list (action) VALUES ('take towel');
ELSE true THEN
INSERT INTO event_list (action) VALUES ('take umbrella');
END IF;

IF 40 > 30
INSERT INTO event_list (action)
VALUES ('put on sweater');

Create a free account to access the full topic