MySQL: STORED PROCEDURES

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

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

Thanks bro!

thank you so much

Can we use date function as parameter

Where can i find this database ???

im confused. you have to change the delimiter every time ?
why hasn't MySQL made a fix for this ?

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

great .. thank u alot

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

You are the best

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

How to debug Stored Procedure in mySQL workbench

great sir

great video

Thnks a lot❤

Thank you, it was easy to understand <3

those using ssms CALL is EXEC

Thanks a lot for this tutorial :)

Is that all in stored procedures?
Can't we use insert, update and delete in stored procedure?

pls explain OUT and INOUT procedures as well

This is absolutely amazing. Thanks

I love you 🥰

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 ❤

HI,
Tell me what if I want to provide Customerid 1 and 2 at one time means 1,2 then what will be my sp?

whats the differences between create functions and procedures guys? =<

I like so much the way you explain everything

Thank You so much!!

Thank you very much!

Why varchar is "WarCHAR" and not "WarKar" when character is "Karactor"

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

Having issue with code in which for some reason. I successfully made 2 stored procedures in a database however the one I did for a parameter that's supposed to be for when finding a particular date within the table when I call the stored procedure it's returns empty set. Yet when I call an asp for all records it'll do so successfully

Whats the difference between stored Procedure and Views? I'm confused.

👏👏

Best video on the subject so far. Thank you!

Please continue this MySql series

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

Can this be used on microsoft sql server?

Don't you have to use a database first?

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