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
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!
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;
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 🙏
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
Simple and straight to the point . Thanks for the video.
This is the video I've been waiting for!! Thank you.
Super se upper sir ...your concept is very easy to understand.
Superrr bro last minute preparation makes crisp and clear 😅 appreciate it ❤
this is the best explanation I have found on this topic!
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.
Thanks, from heart, you explain in very easy way that anyone can understand, keep going
Oh sir ji aap mil gye finally on yt
crystal clear concepts
Sir instead of creating the procedure it is showing me the error that procedure does not exist ,why so ,please help
Fantastic teaching
Thanks for the video Krish !
superbbbbbbbbbbbb smooth explanation ......!!!!!!!!!!!!!
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
Changed
Is this playlist completed ?
@@shivangisaxena5331 god knows 😂 it’s all so scattered in here! Maybe you can just do specific searches and get whatever you need.
Finished watching
Thank you so much sir for such nice videos.
please create a playlist for cursor and trigger also,.....pls make full course of sql as uploaded others,,,thanks
Thanks a lot for clearing the doubt
Its very basic but very informative bro...keep it up😀
make a video for what is trigger and how to create trigger in mysql..
Good explanation
amazing !!!!
nice video bro
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!
Thank you so much.
Hi Krish , When can we expect the video on SubQueries
Can you explain the difference between stored procedure and a view?
Thank you
sir make a Playlist only windows functions because now days only windows function questions asked everywhere in interview
sir when is new batch of full stack data science programm is gonna start??
Can you please create a video on how to import large excel file containing lot of data in MySQL ?
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.
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;
What situations we should consider using stored procedures over MySql queries ?😇
Hi sir Good morning sir this tutorial 9 is the last tutorial in SQL or having some more videos sir
More videos will be coming
@@krishnaik06 Today live is there sir @ 7pm
@@pavib5694 yes
Hello, could you please make a video how to connect and fetch the data from mssql server database stored procedure to Reactjs app.
How to update (refresh) stored procedure in Mysql workbench every minute (automate)
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 🙏
whenever i'm using student.age or anything like this with . in mysql workbench i am getting error. what should i do
Sir how to enroll in internship at I neuron ?
It's Lil difficult for beginners.go slow and easy
Hello Sir
Can you please let me know the procedure for migration of stored procedure from SSMS TO MYSQL
can you please share the dataset?
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?
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
Where we want to practice
rank, dense_rank functions are needed for Data scientist?
yes
@@mohammadfaizanamir3150 ok sir.
its tough
See Here: codebucket.net/details/sql/mssql-server/39/how-to-pass-column-name-as-parameters-in-a-stored-procedure