Learning MySQL - CREATE VIEW

This episode covers how to create and work with views. Be sure to watch to the end to get all the gotchas.

my 4 months of college course and the professor couldn't explain in better way to make me understand, watching your 9 minutes of video and few practices I mastered in views. You are my real professor. thank you.

[cr]

I've pdf files consisting 29 pages to learn about view and you made it just in a 9 mins video! thank you! <3

[inesjesus]

Reviewing this stuff right before my exam and I'm finding your channel super helpful. Thank you very much.

[frankottomanelli]

great video man, learned from you in 5 min what i couldnt learn in 3 hours

[lazytocook]

thanks Steve, very clear and concise.

[alexandreamade]

You got an amazing voice bro, and great content too.

[souravsinha]

Thanks buddy !! Clear Explanation. Loved it. Great Learning Experience.

[theodorname]

Harry Potter Sci-Fi :D
Thanks for the Video. Helped me to understand it now :)

[ivanlik]

Thanks, great channel, why you don't use 'on' for 'join' ?

[ioanricean]

thanks man, learned really fast from u, also very nice voice :D

[kalkalasch]

how did you manage a join without indicating what it should be joined on? or when doing views is it smart enough to understand it on his own?

[ameenqasim]

Thank you so much!!! I will make sure that I like, comment and subscribe this.

[ahmadalghali]

Hi steve, when I do this and save it as a view in MySQL Workbench It becomes read only.. so I cannot select single cells to update... I have seen some stackoverflow answers saying that rules to edit a view is you cannot have joins, but you clearly have joins and its working with you, any tips?

[silentlessons]

I have a view but its saying there is no unique column. How do I make the id of the view unique? maybe using row_number()?

[vivekanandareddymaddela]

I have got a doubt? Since we are using INNER Joins, We should use ON are USING to relate the colomns without that how can we get the result

[meri_gali_or_mera_gaov]

thankyou show much very clear and understandble

[aj]

Great tutorial. But I'm interested to know how did you configured your phpmyadmin's command line. When I install phpmyadmin via xampp, I always get a command line that is behaving differently from yours. What I mean by that, when I do my queries in the sql command line, the results would always be shown in a different page and the command line plus the queries are gone? Whereas, yours is staying in the same page with the results and the sql command line intact.

[robotronix-co-il]

THANKS, how do you make VIEW with parameters such as @ID for example
?

[Musa-btwt]

how do i create a view joining columns from different tables

[vaultdweller]

the problem with view is its limitation like mentioned and u cannot edit the query used to generate the view, the only thing u can do is drop and create new view, which is very frustrating specially if u only need to adjust some minor change on ur query. pls correct me if im wrong with this, bec i tried updating it on phpymadmin it didnt work it throws some errors