Learning MySQL - CASE Operator
Вставка
- Опубліковано 15 вер 2024
- This episode covers the use of the CASE operator in MySQL to dynamically replace column values with different calculated values.
MySQL Playlist: • Learning MySQL - Getti...
SQL file Code GIST: gist.github.co...
MySQL CASE operator reference: dev.mysql.com/...
Спасибо, это как раз та информация, которую я искал :)
Ничего
Keep recording! Your teaching skill is awesome. Is it possible for you to do a video on react life cycle method?
The last video I watched from this channel is how to send image to server. I have created a node server. it is so easy to send image from postman . but I had no idea how to send image from front end to back end . Your video helped me a lot. Not only that , There are many other instance I fell I got I can't go forward , Your video helped me a lot. I learned mongodb. I will definitely follow your MySQL tutorial. I am somewhat good at react. I know the order of react life cycle work . I think the people those who is going to react face much issue with react life cycle method. There are so much video available on UA-cam explaining about react life cycle method. but I don't feel that explanation is not enough to know how to use react life cycle method. That video can only help to understand the order of how react life cycle method run. I think You are the one can help most of the people face this issue. If you have time, Please recede a video on that. Thank you Steve Griffith
I have a whole playlist on React and another on React Native. There are videos about the life cycle in those.
@@SteveGriffith-Prof3ssorSt3v3 I am really sorry. I could not see that play list at the first time I searched. now I got them. Thank you so much
What if you wanna select all columns of the table and use the case statement? Do I really need to select it one by one (Well, It works!) or is there any way to select all columns with the CASE STATEMENT like, for example in the SELECT statement, we have an options to Select it one by one or Select it all:
Select Col1,Col2, etc FROM TABLE
and we have
SELECT * FROM table.
Thank you so much!
The CASE statement is like a switch case statement in JavaScript. You are looking at possible matches for a single value. One value only.
dev.mysql.com/doc/refman/5.7/en/case.html
@@SteveGriffith-Prof3ssorSt3v3 Ow!! Thank you!! 😁
I'm getting error on line 2.
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE genre_id
This is specifically a MySQL tutorial. For MariaDB you need to look at their documentation for the minor differences in syntax.
While ALL relational databases use the SQL language, they all have their own minor differences.
mariadb.com/kb/en/case-statement/
@@SteveGriffith-Prof3ssorSt3v3 thank you very much for the info..