How to Use IF and CASE WHEN in MySQL Workbench SQL Tutorial

#mysql #case #if
alphabench.com/data/mysql-cas...
Please SUBSCRIBE:
ua-cam.com/users/subscription_...
Writing advanced queries in MySQL / SQL:
Using If and CASE WHEN THEN to make decisions in MySQL
Several applied examples using IF and CASE WHEN to do data analysis with MySQL
Download the data used: github.com/mjmacarty/mysql

[@Kenzaki25]

Thank you so much for this! You got a talent for teaching.

[@MattMacarty]

Thank you. Glad it helped.

[@AldairHoyos-zd8kc]

Thanks a lot my friend! I understood everything from this tutorial. Cheers!

[@MattMacarty]

Glad it helped

[@RaviChandR]

Impressive ...easy to understand ..Thank you Macarty..

[@MattMacarty]

Glad it helped!

[@javier3522]

Very well explained, thank you very much!

[@MattMacarty]

Thanks. Glad it helped.

[@joshuaakinmolayan3926]

Fantastic. Very easy to understand.

[@MattMacarty]

Thanks. Glad it helped

[@pp-fr2qs]

Thanks this helped me a lot

[@MattMacarty]

Glad it helped

[@ooogabooga5111]

I'm learning this for fun

[@MattMacarty]

Glad it helped

[@ooogabooga5111]

@@MattMacarty yeah I went from learning all your playlist, to trying to deploy the sakila database on planetscale and learned about scaling constraints with mysql and how vitess addresses it. Learned how to use DBeaver for data import and project management, I'm developing a website for a project and I was learning everything to do it in the right way from start. Thank You again :)

[@zenab571]

btw the function DAYNAME() would've give the day name in a string format and not a number ! great content as always ~

[@MattMacarty]

Thanks. For sure I would probably use DAYNAME, MONTHNAME in practice, but then I would not have been able to show CASE WHEN 😉

[@shwetaaswal3383]

@@MattMacarty great content.
so, can we sort data with the use of dayname, monthname?

[@sportiano3348]

hey man i want if stock less than export_qty appear a message the stock is not enough ?
i try in mysql and sqlite3 but not work?

[@MattMacarty]

Not sure I understand, but it sounds like you might try using an IF function?

[@sumayyaishaq2370]

Hello, I can’t seem to find the stocks sql file on github . Could you put a link that leads to that directly, thanks

[@MattMacarty]

I named it data.csv: github.com/mjmacarty/mysql/blob/main/data.csv

[@user-bl5lh9pc7n]

where can i find the file to download?

[@MattMacarty]

Looks like I forgot to post the link: github.com/mjmacarty/mysql