Create MySQL Database - MySQL Workbench Tutorial
Вставка
- Опубліковано 20 лип 2024
- Upgrade your Clever Techie learning experience:
/ clevertechie
UPDATE! (9/13/19) New features and improvements for Clever Techie Patreons:
1. Download full source code with detailed comments - easy to learn and understand code
2. Weekly source code file updates by Clever Techie - every time I learn new things about a topic I will add it to the source file and let you know about the update - keep up with the latest coding technologies
3. Library of custom Clever Techie functions with descriptive, easy to understand comments - skyrocket coding productivity, code more efficiently by using Clever library of custom re-usable functions
4. Syntax code summary - memorize and review previously learned code faster
4. Organized file structure - access all Clever Techie lessons, source code, graphics, diagrams and cheat sheet from a single workspace - no more searching around for previously covered material and source code - save enormous amount of time and effort
5. Outline of topics the source file covers - fast review of all previously learned coding lessons
6. Access to all full HD 1080p videos with no ads
7. Console input examples - interactive examples that make it easier to understand and learn coding
8. Access to updated PHP Programming Book by Clever Techie
Download this video's source code and additional files here:
/ create-mysql-20819048
`````````````````````````````````````````````````````````````````````````````````````````````
We model a MySQL database using a diagram in MySQL workbench. We then forward engineer the diagram to create MySQL database on the server. MySQL workbench is a powerful tool for modeling and creating databases and we take advantage of it's relationship tool to create many to many relationship between our main movie table, and stars, directors and genres tables. I don't go into too much detail on how the relationships work in this video on purpose, I wanted to make a general overview of how MySQL workbench can be used to quickly created the model of a database with relationships between tables. - Навчання та стиль
That is so awesome! I love that someone created the GUI interface and forward engineer option!
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.
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*
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.
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! 😁
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 :)
You really explained this course super excellent, thanks.
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
extremly usefull saved my day tomorrow is my final lab mysql exam on database management
Good way to teach about many to many relationship between database table. Thank you it helped me
Great presentation style! Very helpful, thanks.
Sir, you are incredible and you are shining beam of humanity's essence - sharing with others and caring for them!
Amazing, amazing video!
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?
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.
Oh bless you 🙏🏾 May you continue to be a light in the dark places . Tysm
thank you so much, needed a quick revision and you really helped me out
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 ?
Very good stuff. Thank you.
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?
Explained very well.
Thank you!
How I can setup Timezone on MySql Workbanch server?
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
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?
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
I didn't know that I can make relational database without fields that store the values of foreign table id.
Nice video.
Thanks :)
Can you use mutually exclusive relationships? cant finde them anywhere
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??
This is great. Thank you!
Ty so much! you are great at explaining!
Just the video i was looking for
when i try to scrape the data, i get the error in $all_data = array_merge($data,$all_data); that Undefined variable: data
Very clear and useful. Thank you.
Cool tutorial man really helpful
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?
great video very helpful and sufficient ! thx !
Nice presentation.
Pls can you help me with the video on how to link MySQL workbench with login page using VS text editor.
Thanx.
Do you have the example of the insert¿
how to call it those tables on the JOIN query?
Thank you so much! You help me a lot
how to download the video of programing with used of mysql
Thanks, Bro! It was really usefull tutorial
SO HELPFUL!!! THANK YOU!!!!
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.
Helped a lot thanks.
Email adresses and URL can be 255 long, if you choose smaller, some users will not be able to be registered correctly.
Thank you for this lovely lesson. Can this also be done on an Android tablet ?
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.
@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.
A very nice tutorial.
Very helpful. Thanks. What did you use to make the initial model diagram?
I used workbench and some Photoshop
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.
Amazing tutorial!
Thank you..very helpful:D
Could you help with a python script for the same?
thanks for this masterpiece i learned a lot.
Thanks for Tutorial
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
Thanks , great video! give me pls the link for the next video
Thank you!
Thank you . Excellent video.
np
Good guy!
Excellent tutorial
your excellent work
Finally a video with a non-indian guy
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 Great Tutorial .
How do I solve error 1064 on Fw engineering? Please. Have a deadline in 4hours
Great stuff clever techie
Thank you!
What if can't connect with my local database? :(
great tutorial
wonderful ... Thanks a ton :)
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 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
Great tutorial, thank you so much!
so usefull....thanks a lot
its so helpful bro i appreciate it thank you for the tutorial Godbless you
This really useful
Please how can I get Ur previous video
why do i have Error 1064: when i try to forward engineering???
How can i get the script?
best for me
Thx. very useful info
Was useful!!
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
Best Video
Thank you for this video :-)
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?
unable to connect to local host
Thanks
I don't really get why you choose "ID" and then don't explain your choice.
Great!
Thankyou
Man! Too many ads in the video.
localhost/phpmyadmin/ site cant be reached
YOU FUCKING SAVED ME RIGHT NOW, BRO. LOVE U!
If I could subscribe more than once I could.
Glad you liked the video so much :)
One movie can be directed by one or many directors, one director can direct none, one or many movies. 😎
It would be better with foreign key explanation
ua-cam.com/video/aKcEfkLxg80/v-deo.html
mybe this helps
too fast at the end