MySQL: STORED PROCEDURES

#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 ;

[BroCodez]

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 ;

[dharmawangsa]

finnaly someone explain stored procedure clearly, thx bro. please more content

[seyonmahendran]

Please come to our university you deserve to be a lecturer😂

[renyirish]

Wow, I love when people simplify things! No need for a giant table with a giant column to give an example. Thank you soooo much, very well explained ❤

[mrhhh]

😅 To be honest, this lesson is more clear than the one from Meta Database Enginnering course. Thanks so much! ❤

[smtxtv]

Clear, concise, direct....but you know that. Thx !

[yvonnetatah]

Best video on the subject so far. Thank you!

[CristianIordache]

I like so much the way you explain everything

[philipking]

Thanks for explaining this so clearly. I now understand the changing of the DELIMITER thing.

[khanhduluong]

What a great explanation! Very clear, straight and easy to understand. Thank you so much!

[al-cadaalachannel]

Thanks ❤ for explaining clearly and simply. I have never seen this explanation before

[skpidis]

This info came just the right time :) Thank you bro!

[ahmadzaini]

Thx bro, even my lecture just ask me to find self the theory, bro you're my hero 😢

[ruthladenegan]

Always looking forward to your post. You make sql so easy

[rubysrivastava]

pls explain OUT and INOUT procedures as well

[teshalex]

Thank you, it was easy to understand <3

[pabloqp]

Hey @BroCode! Great playlist. Love your fancy dark theme! Let me ask since you didn't cover cursors, are they any good? Cheers

[vanshgrover_]

Great explanation, but what about stored procedure using OUT parameter??

[parajf]

How to update (refresh) stored procedure in Mysql workbench every minute (automate)

[cusematt]

ill stick with the dollar signs because i think that's cooler. 😂