Computer scienceFundamentalsSQL and DatabasesDBMSMySQLDB objects

Stored Procedures

Theory

Collect the stored procedure

Report a typo

We have a stored procedure named VerifiedClients that selects records from table clients where verified is true. All parts of the procedure are presented in wrong order. Let's restore the correct syntax of this stored procedure.

Put the items in the correct order
FROM clients
WHERE verified = true;
SELECT *
END;
BEGIN
CREATE PROCEDURE VerifiedClients ()
___

Create a free account to access the full topic