Tutorial 9- MYSQL Stored Procedures -MySQL Complete Playlist

What is a SQL Stored Procedure?
The stored procedure is a prepared SQL query that you can save so that the query can be reused over and over again. So, if the user has an SQL query that you write over and over again, keep it as a stored procedure and execute it. Users can also pass parameters to a stored procedure so that the stored procedure can act based on the parameter value that is given.
SQL playlist: • Tutorial 1- MySQL With...
#mysqltutorial
Subscribe @Krish Naik Vlogs channel for more educational videos on finance and investment
Please donate if you want to support the channel through GPay UPID,
Gpay: krishnaik06@okicici
Telegram link: t.me/joinchat/...
#datanalyst #roadmaptobecomedatanalyst
Please join as a member in my channel to get additional benefits like materials in Data Science, live streaming for Members and many more
/ @krishnaik06
-----------------------------------------------------------------------------------------------------------------------
Connect with me here:
Twitter: / krishnaik06
Facebook: / krishnaik06
instagram: / krishnaik06
-----------------------------------------------------------------------------------------------------------------------

[@username3543]

This is the video I've been waiting for!! Thank you.

[@kasambalumwagi]

Simple and straight to the point . Thanks for the video.

[@yashpawar2693]

Superrr bro last minute preparation makes crisp and clear 😅 appreciate it ❤

[@payalsingh8947]

Super se upper sir ...your concept is very easy to understand.

[@yadavanubhav005]

Hi Krish, I went through all your mySQL videos, very helpful, thanks for this amazing work you are doing. Please upload more videos to this series.

[@elsggonz]

this is the best explanation I have found on this topic!

[@akshaybagal2208]

Please change the number of video . it's 9 instead of 8..... And frankly i know this because i just finished 8th tutorial seconds ago and waiting for this one....Thanks man Keep up the good work

[@krishnaik06]

Changed

[@shivangisaxena5331]

Is this playlist completed ?

[@akshaybagal2208]

@@shivangisaxena5331 god knows 😂 it’s all so scattered in here! Maybe you can just do specific searches and get whatever you need.

[@KAIFBHOMBAL]

Thanks, from heart, you explain in very easy way that anyone can understand, keep going

[@sparshjain7542]

Sir instead of creating the procedure it is showing me the error that procedure does not exist ,why so ,please help

[@_rushyya1668]

Thanks for the video Krish !

[@SciFi-Hist]

Oh sir ji aap mil gye finally on yt

[@satendertanti]

crystal clear concepts

[@111mallesh8]

Fantastic teaching

[@sujitkumar2196]

Its very basic but very informative bro...keep it up😀
make a video for what is trigger and how to create trigger in mysql..

[@sayandippaul4156]

superbbbbbbbbbbbb smooth explanation ......!!!!!!!!!!!!!

[@kunalkumaraiml2365]

Thank you so much sir for such nice videos.

[@anonimo-xz2tg]

Hello Krish Sir,
Thanks a lot for doing such a noble work which helps hundreds of thousands of students. Could you please make a video on month-to-month/ day-to-day/ week-to-week aggregations of sales using sql on a generic example? This might be an intermediate level topic but has so much importance for a wanna-be Data Engineer/ SQL developer. Even a pseudocode to approach such problems will also be helpful
Thanks in advance!

[@nandhakumarkandhasamy5299]

Thanks a lot for clearing the doubt

[@arpitalodha4687]

please create a playlist for cursor and trigger also,.....pls make full course of sql as uploaded others,,,thanks

[@kingsnow6718]

delimiter #
create procedure cnt ( out cn int, in n int )
begin
select count(*) into cn from org where `Number of employees` > n ;
end;
#
delimiter ;
call cnt (@cn,8000);
select @cn as counts;

[@brucebane7401]

amazing !!!!

[@praji1202]

Good explanation

[@sandeepcmudaliar5031]

Hi Krish , When can we expect the video on SubQueries

[@tarunrastogi8802]

Can you explain the difference between stored procedure and a view?

[@HChahra]

Thank you so much.

[@solotraveller8664]

nice video bro

[@-AbhishekMathpati]

Thank you

[@Fly_High.N]

sir when is new batch of full stack data science programm is gonna start??

[@learnwithrc981]

sir make a Playlist only windows functions because now days only windows function questions asked everywhere in interview

[@parajf]

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

[@balajikomma541]

Sir not able to install MySQL sir, it is throwing error. "No compatible servers found. You'll need to cancel this wizard and install one", sir plz help 🙏

[@potentialinvesting8727]

Can you please create a video on how to import large excel file containing lot of data in MySQL ?

[@stelecoms00]

The way I handle is that I write a sql file that works as a loader and load a data whenever I execute this file.

[@pavib5694]

Hi sir Good morning sir this tutorial 9 is the last tutorial in SQL or having some more videos sir

[@krishnaik06]

More videos will be coming

[@pavib5694]

@@krishnaik06 Today live is there sir @ 7pm

[@krishnaik06]

@@pavib5694 yes

[@manasahr430]

Hello, could you please make a video how to connect and fetch the data from mssql server database stored procedure to Reactjs app.

[@shashankpandey1966]

Sir how to enroll in internship at I neuron ?

[@OjasweetaRisingstar]

whenever i'm using student.age or anything like this with . in mysql workbench i am getting error. what should i do

[@nagalakshmi972]

Where we want to practice

[@ayushsharma-br3lc]

Hello Sir
Can you please let me know the procedure for migration of stored procedure from SSMS TO MYSQL

[@chandniyadav6398]

It's Lil difficult for beginners.go slow and easy

[@pranatianuse243]

Hi @Krish Naik,
I have one question what if I want to Pass age value like 27 and 31 at one time?
What will be my stored Procedure?

[@Vikranth_2706]

i think you can put two parameters like(in age1, in age2) and then inside the store procedure you can
select * from student where student.age = age between and student.age = age2;
you can ask it inside the query as "get_student_info(27,31)"
one more thing this is just my opinion on it and do some research on it because your question various way to solve this so yeah

[@JD-oc3cd]

What situations we should consider using stored procedures over MySql queries ?😇

[@ganeshgunjal4220]

rank, dense_rank functions are needed for Data scientist?

[@mohammadfaizanamir3150]

yes

[@ganeshgunjal4220]

@@mohammadfaizanamir3150 ok sir.

[@ajaydalaya2195]

its tough

[@fzrtechnology1891]

See Here: codebucket.net/details/sql/mssql-server/39/how-to-pass-column-name-as-parameters-in-a-stored-procedure