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.
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?
Views are intended to be read only. They can be regenerated but shouldn't be edited. If you need to edit the data then a TEMP TABLE is a better option.
Generally with inner joins you will use ON to connect the tables yes. You can also use USING. The two are very similar. Here is a good answer about their similarities stackoverflow.com/questions/11366006/mysql-join-on-vs-using
Best practice was that I should have included the `ON`. This simple example worked because I was doing a WHERE clause filter on the data. I was creating a bigger dataset than needed and reducing it with the WHERE. I should have added the ON.
@@SteveGriffith-Prof3ssorSt3v3 great tutorials thank you 've learned a lot from you. in the particular tutorial there is a small error. without ON movie list is wrong for example labyrinth movie is fantasy not sci-fi. without ON , it will just make every movie as sci-fi. we need ON g.genre_id=m.genre_id OR we can have this instead of ON-> using(genre_id)
great tutorials thank you 've learned a lot from you. in the particular tutorial there is a small error. without ON movie list is wrong for example labyrinth movie is fantasy not sci-fi. without ON , it will just make every movie as sci-fi. we need ON g.genre_id=m.genre_id OR we can have this instead of ON-> using(genre_id)
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.
IF you are talking about being able to do custom filters of the data in a view then what you probably want to use is either a Stored Function or a Stored Procedure. Those let you pass in parameters. You can create the View of the data which will keep the data up to date for a specific query. Then you can use the VIEW in a Function or Stored Procedure.
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
That limitation is true. The purpose of the views is for efficiency when running your queries. They are not something that you should be changing. If you need to change the query frequently then consider stored procedures and temporary tables.
routines - functions and procedures are dynamic ways of working with data from multiple sources and manipulating that data. A view is a like a modified table that you create because you frequently access the data in the same way. The process that creates the view stays the same, the result stays in the same structure and is tied to actual tables. A View is data. Routines are a process.
I'm primarily a web developer and teach web development. I need to test on different browsers and be able to use and demonstrate the dev tools in all the browsers.
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.
I've pdf files consisting 29 pages to learn about view and you made it just in a 9 mins video! thank you!
Reviewing this stuff right before my exam and I'm finding your channel super helpful. Thank you very much.
thanks Steve, very clear and concise.
great video man, learned from you in 5 min what i couldnt learn in 3 hours
Harry Potter Sci-Fi :D
Thanks for the Video. Helped me to understand it now :)
Thanks buddy !! Clear Explanation. Loved it. Great Learning Experience.
Best quality of voice so far
You got an amazing voice bro, and great content too.
Thank you so much!!! I will make sure that I like, comment and subscribe this.
What a course! Great job. Thanks
Thank you. Clear and direct.
thanks man, learned really fast from u, also very nice voice :D
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?
Views are intended to be read only. They can be regenerated but shouldn't be edited. If you need to edit the data then a TEMP TABLE is a better option.
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()?
When you are creating the view you need to be bringing in a unique column. The primary key of the other table is the best choice.
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
Generally with inner joins you will use ON to connect the tables yes. You can also use USING. The two are very similar. Here is a good answer about their similarities stackoverflow.com/questions/11366006/mysql-join-on-vs-using
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?
Best practice was that I should have included the `ON`. This simple example worked because I was doing a WHERE clause filter on the data. I was creating a bigger dataset than needed and reducing it with the WHERE. I should have added the ON.
@@SteveGriffith-Prof3ssorSt3v3 great tutorials thank you 've learned a lot from you. in the particular tutorial there is a small error. without ON movie list is wrong for example labyrinth movie is fantasy not sci-fi. without ON , it will just make every movie as sci-fi. we need ON g.genre_id=m.genre_id
OR we can have this instead of ON-> using(genre_id)
thankyou show much very clear and understandble
great tutorials thank you 've learned a lot from you. in the particular tutorial there is a small error. without ON movie list is wrong for example labyrinth movie is fantasy not sci-fi. without ON , it will just make every movie as sci-fi. we need ON g.genre_id=m.genre_id
OR we can have this instead of ON-> using(genre_id)
Thanks a lot
Thanks , great channel , why you don't use 'on' for 'join' ?
Thanks. I do use on with joins. Sometimes in a simple demo I might not.
thank you steve!
Thanks for the info sir!
👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻 outstanding!
Sweet !!! 😋
Thanks a lot 🙏🏿
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.
Look right below where I am typing. See the checkbox "Show this query here again".
@@SteveGriffith-Prof3ssorSt3v3 ty so much. Didn't expect you to reply so fast. I've fixed it now thank you.
THANKS ,how do you make VIEW with parameters such as @ID for example
?
IF you are talking about being able to do custom filters of the data in a view then what you probably want to use is either a Stored Function or a Stored Procedure. Those let you pass in parameters.
You can create the View of the data which will keep the data up to date for a specific query. Then you can use the VIEW in a Function or Stored Procedure.
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
That limitation is true. The purpose of the views is for efficiency when running your queries. They are not something that you should be changing. If you need to change the query frequently then consider stored procedures and temporary tables.
@@SteveGriffith-Prof3ssorSt3v3 thanks for the info steve, ill check stored procedures and temporary tables then :)
how do i create a view joining columns from different tables
That is exactly what I show in the video.
bella voce
thanks
Thank you sir!!!
thank you sir
Thank you ❤️
Thank you :)
Can I create a view from an array?
Views are data retrieved from tables.
Thank you
View vs Routine
What's the difference? thank you!
routines - functions and procedures are dynamic ways of working with data from multiple sources and manipulating that data. A view is a like a modified table that you create because you frequently access the data in the same way. The process that creates the view stays the same, the result stays in the same structure and is tied to actual tables. A View is data. Routines are a process.
@@SteveGriffith-Prof3ssorSt3v3 So... view is just like linked columns of another table? Anyway thank you for the answer :)
The Hobbit is Sci-Fi? Lol!
In the original data it, and others, were Fantasy. They got changed in previous tutorials in the series.
I couldn't help but to notice how many browsers you have why does one man need all of them are you "trying to catch them all"
I'm primarily a web developer and teach web development. I need to test on different browsers and be able to use and demonstrate the dev tools in all the browsers.
why is Conan the Barbarian a sci-fi movie
These are the types of things that happen when you experiment with your data while teaching people. :P