MySQL Create Function

[@selinawale2108]

The explanation is the best but please do Zoom it so we can see the syntax.

[@DATA_rockerz]

Great explanation. found this video by chance. would be happy if you can more videos on SQL esp. SUBQUERIES, which are very complicated. thanks

[@westarpro9349]

Спасибо за обучающие видео)

[@ranvijaymehta]

Thank you so much now function looks very easy..

[@Jason-zj7ex]

amazing vid !

[@rodneytapit5636]

Thank you for making this clear example. I'm new to mysql, can you please see why the following is not working. I'm wishing to use a stored function in a stored procedure's where clause. But the procedure doesn't return any records - the product id does exist. Both compile without errors. And if I execute the set_clause() it returns the expected 'products.id=6'. I'm using the latest MySql build 8.0.34. CREATE DEFINER=`root`@`localhost` PROCEDURE `prod_srch`() READS SQL DATA BEGIN select * from products WHERE set_clause() /* this returns no records */ -- where products.id=6 -- this returns expected 1 record END CREATE DEFINER=`root`@`localhost` FUNCTION `set_clause`() RETURNS varchar(255) CHARSET utf8mb4 NO SQL DETERMINISTIC BEGIN declare rv varchar(255); set rv := "products.id=6"; RETURN (rv); END

[@roxanad24]

Thank you for your video. But please make bigger to can see my sql file

[@snehaldubey4897]

Thank you..

[@stuo9301]

That was helpful.

[@stuo9301]

I wish that you explain the whole course

[@briankyletan6347]

@@stuo9301 Glad to help! I'm guessing you are in a Database course. I'd be happy to do more SQL tutorials!

[@supermarioxta5894]

i fucking love you

[@gretajaie]

Would you happen to be the Brian from FTPSS?

[@briankyletan6347]

Omg Greta. How are you?! And yes, ftpss Brian Tan.

[@labbdogg2929]

CREATE FUNCTION `Ticket_function` (item NUMERIC(8,2)) RETURNS CHAR(18) DETERMINISTIC BEGIN DECLARE myitem CHAR(18); SET myitem = CASE WHEN item < 1000 THEN 'Small Ticket Item' WHEN item BETWEEN 1000 AND 10000 THEN 'Medium Ticket Item' WHEN item > 10000 THEN 'Big Ticket Item' ELSE 'For Sale' END; RETURN myitem; END; Is this correct as well?

[@briankyletan6347]

Looks good to me!