This is helping me pass a class in uni. I'm working on a database about boardgame tournaments, so it's different but if I pass this class, it's gonna be in large part thanks to this video. All the kudos to you.
I don't know the first about SQL or databasing or anything but I am able to follow your video and I appreciate the time you've put in to these videos to make SQL accessible for lay people like myself.
YOU ARE A GOD! Thank you so much for making this video. I have been struggling for 4 days trying to figure out how to connect to my own database using a java connector and I think this may just be the key I was missing. thank you SO much! *HUGS*
It is incledible! Great tutorial and great presentation. I have a project with about 50 tables and many relationships. I bumped into your video and solved all my complexity problems with that! Many, many thanks to you. :)
@13:30 It says movies_has_directors because it is meant to be read either forward or backward, Movies have directors and directors have movies. A movies_directors relationship could be any relationshiip 1:1 or 1:n or n:m and therefore is ambiguous unless you already know what it is.
Im trying to get a webserver database running for my android app and This is exactly the info I've been looking for! Thank you so much, you're a great teacher! 😁
Thanks. I am facing a problem. I am new to SQL and downloaded a database from the lecture but after uploading it to MYSQL Workbench, it shows error- "error code 1049 unknown database". However, the database file type extension is .sql and it is error free. Please suggest.
thank you so much for this :) I have been looking to create a database of the movies on my Plex server. How would we go about inputting the data into the tables? Would we have to input all the movie, actor, director, genre information separately?
Thank you for the movie. I'm a beginning user and couldn't figure out how to export a sql file. After viewing this I learned I needed to forward engineer the model before I could export it. Thank you.
Thank you for this tutorial. I have two questions and want your thought to be clear. 1. When populating the tables with data which table should be consider first since there exist relationships and some constraints. 2. Do we also populate the intermediate tables that were created as a result of the many to many relationships (.i.e. movies_directors, movies_genres and movies_stars)? Or these are just used for relationships
Hy Clever Techie! Great tut!! Im trying to build a Real Estate Website Database Schema, but i don´t have much experience. But i can use this tutorial for that?...its kind of the same thing? Can u give me some general hints??
How to increase a font size of user interface? Because my display has too big resolution and I cannot see UI items names. I've tried all options but I only made editor font bigger.
I'm confused on the phpmyadmin part. Can I download that if I have a Mac? Huge SQL newbie over here so I was following pretty well with the workbench stuff but then got confused once you went to the phpmyadmin part
Hi I love your video thank you so much for your advices. But there's a point that i didn't understand. In fact in the stars & directors tables you select Unique box for "name" attribute. But I learnt that attritbute like name,lastname,firstname cant be unique cause it's possible to have several people with the same first and last name. So can you explain me the reason why you did that ?
What's the point of using "phpMyAdmin" on a development system if you are already using "MySQL Workbench". Anything you can do with "phpMyAdmin" can also be done with "MySQL Workbench".
Thanks a lot for the tutorial video. Just a suggestion to make your chanel even: can you organize your playlist in a clearer way, i am having trouble finding the "next video" that you mentioned in the end of this video.
I don't actually understand why the relation of movies to genres is many to many, because 1 movie has only 1 genre ,and 1 genre can be assigned to many movies so its a 1:n relationship. Please correct me if I'm wrong!
I'm using Windows 7 theme, and yes if you want to new relations with existing database model, you first have to "reverse engineer it". So to do that go to Database -> Reverse Engineer and then pick the one you want generated as a diagram.
Eek! I'm a complete MySQL newbie, and not ready to start into PHP yet. What platform do I run the code you provide to parse the IMDB file? Sorry for being such an ignoramus.
hi there, great work btw. When I'm trying to connect localhost/phpmyadmin, it says browser can't connect to the server. I've checked MySQL status(up and running) and also I am able to connect in my terminal and create db etc... How can't I connect to my phpmyadmin page?
Database is used usually for PHP programing lanangue, u know how to make in html a database.. i dont know if its possible I'm just 70% percent but please if u can or anyone... Explain me . I want to understand :)
man... this video, sure if you know what he is talking about its good but if you are starting from literally 0 (you just installed workbench and don't know anything else) and want to know how to do it this is NOT the video to learn how, so many unanswered questions from the start.
This is helping me pass a class in uni. I'm working on a database about boardgame tournaments, so it's different but if I pass this class, it's gonna be in large part thanks to this video. All the kudos to you.
I can also help you with a hug.
That is so awesome! I love that someone created the GUI interface and forward engineer option!
I don't know the first about SQL or databasing or anything but I am able to follow your video and I appreciate the time you've put in to these videos to make SQL accessible for lay people like myself.
YOU ARE A GOD! Thank you so much for making this video. I have been struggling for 4 days trying to figure out how to connect to my own database using a java connector and I think this may just be the key I was missing. thank you SO much! *HUGS*
It is incledible! Great tutorial and great presentation. I have a project with about 50 tables and many relationships. I bumped into your video and solved all my complexity problems with that! Many, many thanks to you. :)
You're welcome :)
@13:30 It says movies_has_directors because it is meant to be read either forward or backward, Movies have directors and directors have movies. A movies_directors relationship could be any relationshiip 1:1 or 1:n or n:m and therefore is ambiguous unless you already know what it is.
Im trying to get a webserver database running for my android app and This is exactly the info I've been looking for! Thank you so much, you're a great teacher! 😁
I learn fast on your way in tutoring us on "HOW TO" on stuffs, very easy and concise.
th-cam.com/video/GHeWQPY1DcI/w-d-xo.html
extremly usefull saved my day tomorrow is my final lab mysql exam on database management
Oh bless you 🙏🏾 May you continue to be a light in the dark places . Tysm
Sir, you are incredible and you are shining beam of humanity's essence - sharing with others and caring for them!
Amazing, amazing video!
mysql/django/python新教程：th-cam.com/video/61RE4DZ33oY/w-d-xo.html
Just the video i was looking for
Thank you for this lovely lesson. Can this also be done on an Android tablet ?
Email adresses and URL can be 255 long, if you choose smaller, some users will not be able to be registered correctly.
will this many to many create a combination of unique keys in the movies_directors? if there is not unique combination duplication might occur right?
Finally a video with a non-indian guy
Very helpful. Thanks. What did you use to make the initial model diagram?
I used workbench and some Photoshop
Thanks. I am facing a problem. I am new to SQL and downloaded a database from the lecture but after uploading it to MYSQL Workbench, it shows error- "error code 1049 unknown database". However, the database file type extension is .sql and it is error free. Please suggest.
thank you so much, needed a quick revision and you really helped me out
You really explained this course super excellent, thanks.
thank you so much for this :) I have been looking to create a database of the movies on my Plex server. How would we go about inputting the data into the tables? Would we have to input all the movie, actor, director, genre information separately?
Thank you for the movie. I'm a beginning user and couldn't figure out how to export a sql file. After viewing this I learned I needed to forward engineer the model before I could export it. Thank you.
Great stuff clever techie
Thank you!
thanks for this masterpiece i learned a lot.
Good way to teach about many to many relationship between database table. Thank you it helped me
Thank you for this tutorial. I have two questions and want your thought to be clear. 1. When populating the tables with data which table should be consider first since there exist relationships and some constraints. 2. Do we also populate the intermediate tables that were created as a result of the many to many relationships (.i.e. movies_directors, movies_genres and movies_stars)? Or these are just used for relationships
th-cam.com/video/GHeWQPY1DcI/w-d-xo.html
Amazing tutorial!
I didn't know that I can make relational database without fields that store the values of foreign table id.
Nice video.
Thanks :)
Great presentation style! Very helpful, thanks.
Hy Clever Techie! Great tut!! Im trying to build a Real Estate Website Database Schema, but i don´t have much experience. But i can use this tutorial for that?...its kind of the same thing? Can u give me some general hints??
YOU FUCKING SAVED ME RIGHT NOW, BRO. LOVE U!
How to increase a font size of user interface? Because my display has too big resolution and I cannot see UI items names. I've tried all options but I only made editor font bigger.
Not sure, haven't played with font sizes yet, I'll let you know if I figure it out.
I'm confused on the phpmyadmin part. Can I download that if I have a Mac? Huge SQL newbie over here so I was following pretty well with the workbench stuff but then got confused once you went to the phpmyadmin part
Hi I love your video thank you so much for your advices. But there's a point that i didn't understand. In fact in the stars & directors tables you select Unique box for "name" attribute. But I learnt that attritbute like name,lastname,firstname cant be unique cause it's possible to have several people with the same first and last name. So can you explain me the reason why you did that ?
Doesn't primary key automatically make it not null? Why should we select both? And if we have to, why not select unique too then?
Very clear and useful. Thank you.
What's the point of using "phpMyAdmin" on a development system if you are already using "MySQL Workbench". Anything you can do with "phpMyAdmin" can also be done with "MySQL Workbench".
If I could subscribe more than once I could.
Glad you liked the video so much :)
great video very helpful and sufficient ! thx !
Ty so much! you are great at explaining!
The only thing I changed is to not start the server with the system. Now I run into problems. How do I start it manually?
its so helpful bro i appreciate it thank you for the tutorial Godbless you
why do i have Error 1064: when i try to forward engineering???
Thanks a lot for the tutorial video. Just a suggestion to make your chanel even: can you organize your playlist in a clearer way, i am having trouble finding the "next video" that you mentioned in the end of this video.
Cool tutorial man really helpful
Excellent tutorial
How do I solve error 1064 on Fw engineering? Please. Have a deadline in 4hours
Please how can I get Ur previous video
Very good stuff. Thank you.
What is the difference between creating a relationship with a continuous or discontinuous line?
Continuous line - Value has to be specified
Discontinuous line - Value can be null
Can you use mutually exclusive relationships? cant finde them anywhere
Helped a lot thanks.
Thank you . Excellent video.
np
Thanks Great Tutorial .
Could you help with a python script for the same?
Thanks, Bro! It was really usefull tutorial
Do you have the example of the insert¿
This really useful
I don't actually understand why the relation of movies to genres is many to many, because 1 movie has only 1 genre ,and 1 genre can be assigned to many movies so its a 1:n relationship. Please correct me if I'm wrong!
"Some movie" Genre : Drama, Fantasy ... that's why
A very nice tutorial.
when i try to scrape the data, i get the error in $all_data = array_merge($data,$all_data); that Undefined variable: data
What if can't connect with my local database? :(
Which workbench theme are you using? and is there any way that I can create new model (drawing relations) with existing database?
I'm using Windows 7 theme, and yes if you want to new relations with existing database model, you first have to "reverse engineer it". So to do that go to Database -> Reverse Engineer and then pick the one you want generated as a diagram.
Clever Techie Thank you so much! Sorry for my bad English.
Eek! I'm a complete MySQL newbie, and not ready to start into PHP yet. What platform do I run the code you provide to parse the IMDB file? Sorry for being such an ignoramus.
Cathy Bourner You need to run it on a server. Either local server like Apache or your website server. Lookup Xamp or Mamp.
I don't really get why you choose "ID" and then don't explain your choice.
Thank you for this video :-)
how to call it those tables on the JOIN query?
SO HELPFUL!!! THANK YOU!!!!
how to download the video of programing with used of mysql
hi there, great work btw. When I'm trying to connect localhost/phpmyadmin, it says browser can't connect to the server. I've checked MySQL status(up and running) and also I am able to connect in my terminal and create db etc... How can't I connect to my phpmyadmin page?
How I can setup Timezone on MySql Workbanch server?
Was useful!!
Thx. very useful info
Database is used usually for PHP programing lanangue, u know how to make in html a database.. i dont know if its possible I'm just 70% percent but please if u can or anyone... Explain me . I want to understand :)
html is a markup language, works only in the client side, php works in the server side
Thank you..very helpful:D
localhost/phpmyadmin/ site cant be reached
Nice presentation.
Pls can you help me with the video on how to link MySQL workbench with login page using VS text editor.
Thanx.
Great tutorial, thank you so much!
One movie can be directed by one or many directors, one director can direct none, one or many movies. 😎
great tutorial
wonderful ... Thanks a ton :)
How can i get the script?
your excellent work
unable to connect to local host
so usefull....thanks a lot
Thanks for Tutorial
Great!
thank you
Thank you!
Best Video
Thanks , great video! give me pls the link for the next video
Thankyou
man... this video, sure if you know what he is talking about its good but if you are starting from literally 0 (you just installed workbench and don't know anything else) and want to know how to do it this is NOT the video to learn how, so many unanswered questions from the start.
it won't let me setup the localhost connection
I reinstalled the server and it works!
dev.mysql.com/downloads/shell/
Are you sure you installed my SQL after this tool?
@@richardb8104 How did you reinstall the server?
Good guy!
Man! Too many ads in the video.
too fast at the end
best for me
It would be better with foreign key explanation
th-cam.com/video/aKcEfkLxg80/w-d-xo.html
mybe this helps