MySQL: STORED PROCEDURES

From the creator

#MySQL #tutorial #course ----- Example 1 ----- DELIMITER $$ CREATE PROCEDURE get_customers() BEGIN SELECT * FROM customers; END $$ DELIMITER ; CALL get_customers(); DROP PROCEDURE get_customers; ----- Example 2 ----- DELIMITER $$ CREATE PROCEDURE find_customer(IN id INT) BEGIN SELECT * FROM customers WHERE customer_id = id; END $$ DELIMITER ; ----- Example 3 ----- DELIMITER $$ CREATE PROCEDURE find_customer(IN f_name VARCHAR(50), IN l_name VARCHAR(50)) BEGIN SELECT * FROM customers WHERE first_name = f_name AND last_name = l_name; END $$ DELIMITER ;

Published 2022-11-22 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.