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. :)
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! 😁
@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.
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.
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.
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".
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
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.
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 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
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?
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.
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 :)
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??
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 ?
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?
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.
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 :)
extremly usefull saved my day tomorrow is my final lab mysql exam on database management
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.
ua-cam.com/video/GHeWQPY1DcI/v-deo.html
@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.
Oh bless you 🙏🏾 May you continue to be a light in the dark places . Tysm
Just the video i was looking for
Sir, you are incredible and you are shining beam of humanity's essence - sharing with others and caring for them!
Amazing, amazing video!
Finally a video with a non-indian guy
Great stuff clever techie
Thank you!
thanks for this masterpiece i learned a lot.
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 so much, needed a quick revision and you really helped me out
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 :)
Email adresses and URL can be 255 long, if you choose smaller, some users will not be able to be registered correctly.
Good way to teach about many to many relationship between database table. Thank you it helped me
You really explained this course super excellent, thanks.
Thank you for this lovely lesson. Can this also be done on an Android tablet ?
Very clear and useful. Thank you.
Great presentation style! Very helpful, thanks.
Excellent tutorial
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.
great video very helpful and sufficient ! thx !
If I could subscribe more than once I could.
Glad you liked the video so much :)
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".
Thank you . Excellent video.
np
This really useful
its so helpful bro i appreciate it thank you for the tutorial Godbless you
Thanks Great Tutorial .
Ty so much! you are great at explaining!
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?
One movie can be directed by one or many directors, one director can direct none, one or many movies. 😎
Helped a lot thanks.
Cool tutorial man really helpful
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
ua-cam.com/video/GHeWQPY1DcI/v-deo.html
Very helpful. Thanks. What did you use to make the initial model diagram?
I used workbench and some Photoshop
YOU FUCKING SAVED ME RIGHT NOW, BRO. LOVE U!
why do i have Error 1064: when i try to forward engineering???
Very good stuff. Thank you.
A very nice tutorial.
I don't really get why you choose "ID" and then don't explain your choice.
Thx. very useful info
Thank you for this video :-)
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
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?
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.
How do I solve error 1064 on Fw engineering? Please. Have a deadline in 4hours
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?
SO HELPFUL!!! THANK YOU!!!!
Thanks, Bro! It was really usefull tutorial
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.
Was 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
great tutorial
Please how can I get Ur previous video
What if can't connect with my local database? :(
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
your excellent work
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..very helpful:D
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.
thank you
Could you help with a python script for the same?
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
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??
when i try to scrape the data, i get the error in $all_data = array_merge($data,$all_data); that Undefined variable: data
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 ?
so usefull....thanks a lot
Thanks for Tutorial
Do you have the example of the insert¿
Great!
how to download the video of programing with used of mysql
Best Video
unable to connect to local host
wonderful ... Thanks a ton :)
localhost/phpmyadmin/ site cant be reached
how to call it those tables on the JOIN query?
Can you use mutually exclusive relationships? cant finde them anywhere
Great tutorial, thank you so much!
Thank you!
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.
Thankyou
How can i get the script?
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?
Nice presentation.
Pls can you help me with the video on how to link MySQL workbench with login page using VS text editor.
Thanx.
Good guy!
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.
As an accountant, I cringed each time you pronounced "gross" as "grahs".
Still, great video, good sir
mysql/django/python新教程：ua-cam.com/video/61RE4DZ33oY/v-deo.html
Man! Too many ads in the video.
best for me
GOOD
too fast at the end
It would be better with foreign key explanation
ua-cam.com/video/aKcEfkLxg80/v-deo.html
mybe this helps