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

i fucking love you

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

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

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?

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

My professor told us that parameters cannot be passed by reference in C (the said thing is only possible in C++) and they're passed by adress. I currently use VS 2022 and I get errors when trying to declare function parameters with '&" eg: void fun(int &var). Why is this?

Thank you so much now function looks very easy..

Would you happen to be the Brian from FTPSS?

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

That was helpful.

amazing vid !

Thank you..