Learning MySQL - Stored Functions

[@MeshTheSnake]

Best audio on a tutorial I’ve ever heard

[@PB-ie8cj]

He's the Bob Ross of computer science tutorials

[@lexicon77]

Yes.

[@gkrocksyoursocks]

Thank you so much, I'm working on a Data Engineering cert on Coursera and they sped through the explanation of MYSQL Functions, this helped so much and you explained things very clearly.

[@Alex0n05]

I agree. I’m doing the same cert and this video was very helpful, thank you!

[@burgerbeatz6293]

Great Tutorial, Tanks a lot!
The cat talking to the dog is the icing on the cake though :)

[@andrathema4]

Since Yesterday I've been watching your MySQL playlist and I thought I've heard a cat in an other video, and now it's confirmed :)

[@SteveGriffith-Prof3ssorSt3v3]

2 dogs. 2 cats. :)

[@andrathema4]

Awesome :)

[@sacrificiallamb5452]

This helped a ton for my college stuff!! Thank you for the video!!

[@user-rk7dm1xm3r]

Awesome. So simple

[@davidclark9086]

Very well made and useful video.

[@mehmetkaya4330]

Nicely explained! Thank you

[@WillowCreekGamesLLC]

Thank you so much :) made functions very clear for me.

[@KeffelewAssefa]

Thank you

[@DavisTibbz]

Thanks You have a Movie Narrator voice!

[@triizzzz7316]

Best tutorial!! Tysm!!!

[@julianachaves980]

Great video, thanks!

[@flzssolutionsgmbh-powerkno183]

Thanks Steve, helped a lot 👍😉

[@robin4046]

Thank You.

[@blktux]

Thank you so much

[@suvanshdev7567]

nice tutorials!

[@sandhiyas5935]

Try to make complex stored procedure and stored fn videos that would be helpful :)

[@madvier_8336]

Clear totorial :3

[@Nefrobgaltis]

pro guide!!! thanks

[@leona5162]

i love you!!!!!!

[@karmnshawki1226]

thanks very much :)

[@muruganamirthalingam6023]

How to access Stored Functions in laravel controller? if you have any solution, please mention here.

[@millinumwama4593]

Sir, I'm new to MYSQL and I'm trying to create a function to create usernames for users.
Create function username(first_name CHAR(20), lust_name CHAR(25))
RETURN CONCAT (first_letter of the first_name, ' ', lust_name);
Can you help me complete this one??

[@SteveGriffith-Prof3ssorSt3v3]

Here is the list of string functions that you can use dev.mysql.com/doc/refman/8.0/en/string-functions.html

[@sirsanti]

Hello Sir! I need your help
What is wrong with my function?
SELECT canid, cfullname(cfirstname, clastname)
AS fn
WHERE cno = '77'
FROM nclcearth2020db.tblcandidates;

[@sirsanti]

I just got the correct code/ :)
SELECT canid, cno, cfullname(cfirstname, clastname)
AS fn FROM nclcearth2020db.tblcandidates
WHERE cno = '77';

[@SteveGriffith-Prof3ssorSt3v3]

FROM comes before WHERE clauses

[@darter1990]

Professor, video number 28 in playlist is "private"; is that normal?

[@SteveGriffith-Prof3ssorSt3v3]

I'm recording ahead. Each day one or two more get released

[@keelergaming3624]

hi, i am new to mysql. I have a requirement, where based on ID passed i need to return its corresponding value, i could use a stored procedure for that. but i want to create a function so i can use it in future.

[@SteveGriffith-Prof3ssorSt3v3]

Sure. You could do that with either a stored function or stored procedure. Since it is so simple a function probably makes more sense.