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!
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
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;
This is the video I've been waiting for!! Thank you.
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.
Sir instead of creating the procedure it is showing me the error that procedure does not exist ,why so ,please help
Simple and straight to the point . Thanks for the video.
Super se upper sir ...your concept is very easy to understand.
this is the best explanation I have found on this topic!
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.
Thanks, from heart, you explain in very easy way that anyone can understand, keep going
please create a playlist for cursor and trigger also,.....pls make full course of sql as uploaded others,,,thanks
Its very basic but very informative bro...keep it up😀
make a video for what is trigger and how to create trigger in mysql..
Thanks for the video Krish !
Can you explain the difference between stored procedure and a view?
Thank you so much sir for such nice videos.
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!
Hi Krish , When can we expect the video on SubQueries
Oh sir ji aap mil gye finally on yt
crystal clear concepts
Fantastic teaching
sir when is new batch of full stack data science programm is gonna start??
sir make a Playlist only windows functions because now days only windows function questions asked everywhere in interview
superbbbbbbbbbbbb smooth explanation ......!!!!!!!!!!!!!
Thanks a lot for clearing the doubt
amazing !!!!
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 🙏
Thank you so much.
nice video bro
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.
whenever i'm using student.age or anything like this with . in mysql workbench i am getting error. what should i do
Good explanation
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
Thank you
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)
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
Sir how to enroll in internship at I neuron ?
Hello Sir
Can you please let me know the procedure for migration of stored procedure from SSMS TO MYSQL
Where we want to practice
rank, dense_rank functions are needed for Data scientist?
yes
@@mohammadfaizanamir3150 ok sir.
It's Lil difficult for beginners.go slow and easy
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;
its tough
What situations we should consider using stored procedures over MySql queries ?😇
See Here: codebucket.net/details/sql/mssql-server/39/how-to-pass-column-name-as-parameters-in-a-stored-procedure