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 ;

[@annam3533]

Great

[@MasterZhao]

Can you do an example where you DECLARE variables and use CONTINUE HANDLER FOR SQLEXCEPTION?

[@ahmadzaini1297]

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

[@dharmawangsa9592]

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

[@seyonmahendran7182]

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

[@smtxtv]

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

[@aldrinjohnencina6153]

thank you so much clear explaination.

[@CristianIordache22091996]

I like so much the way you explain everything

[@yvonnetatah2084]

Best video on the subject so far. Thank you!

[@AronLuchan]

Thank you very much!

[@gabrielodiase7357]

This is absolutely amazing. Thanks

[@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 ❤

[@khantechsolution]

great sir

[@cusematt23]

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

[@parajf]

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

[@philipking1788]

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

[@sk00pidis]

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

[@chathurid]

Thank You so much!!

[@lubna99]

great .. thank u alot

[@khanhduluong4355]

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

[@rominasepulveda570]

great video

[@user-bt3zq2sl6r]

thank you so much

[@al-cadaalachannel3194]

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

[@ruthladenegan4075]

You are the best

[@sahaninimesha9895]

Thnks a lot❤

[@nicholasiliev]

Thanks bro!

[@productivityaccount7705]

Can you please do a video on cursor

[@ruthladenegan4075]

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

[@mrhhh693]

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

[@nagendradevara1]

Please continue this MySql series

[@teshalex]

Thank you, it was easy to understand

[@SistaYana-ru1yc]

I love you 🥰

[@rubysrivastava2288]

pls explain OUT and INOUT procedures as well

[@ATGalaxy94]

Where can i find this database ???

[@thunderhamilton1]

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

[@pabloqp7929]

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

[@SIDEKICKONYOUTUBE]

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

[@pranatianuse243]

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?

[@HoaNguyen-uq8vh]

How to debug Stored Procedure in mySQL workbench

[@vanshgrover_19]

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

[@tenebrae1191]

👏👏

[@Ritesh-pv4yi]

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

[@phongtranquoc7557]

whats the differences between create functions and procedures guys? =

[@fearless6141]

Can we use date function as parameter

[@ekcanok2412]

Can this be used on microsoft sql server?

[@queryhsje7514]

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

[@TheAnimeSounds]

Procedure is just an action that executes your statements
Views are virtual tables (your rensponses), unlike normal tables that hold data and are stored in Databases, views create tables with data filled dynamically on the fly. You use those if you dont really need store specific tables, but said tables can help ya with solving some problem / calculation.

[@queryhsje7514]

@@TheAnimeSounds Oh ok, thanks!

[@theBATfamiliar]

Thanks a lot for this tutorial :)

[@sundaypodcom]

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

[@cbbcbb6803]

Don't you have to use a database first?

[@mitigozman-pop2]

He did create a database. Otherwise he wouldn't be able to extract data. He did so in previous videos of this series.

[@moe583]

Can you please do a course on developing a web application with nodeJS, there isn't any good tutorials on youtube for that and I think you would be great at breaking it down.