Тёмный

Create MySQL Database - MySQL Workbench Tutorial 

Clever Techie
Подписаться 102 тыс.
Просмотров 622 тыс.
50% 1

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.

Хобби

Опубликовано:

 

2 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 140   
@FacePalmProduxtnsFPP
@FacePalmProduxtnsFPP 5 лет назад
That is so awesome! I love that someone created the GUI interface and forward engineer option!
@gatorslife22
@gatorslife22 5 лет назад
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*
@alexl8632
@alexl8632 5 лет назад
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.
@daniii3915
@daniii3915 4 года назад
I can also help you with a hug.
@RosnerTheWriter
@RosnerTheWriter 6 лет назад
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.
@albertolopez7073
@albertolopez7073 3 года назад
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! 😁
@sahin8649
@sahin8649 7 лет назад
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. :)
@clevertechie
@clevertechie 7 лет назад
You're welcome :)
@EdwinSepulvedaLE
@EdwinSepulvedaLE 7 лет назад
You really explained this course super excellent, thanks.
@GreatAdib
@GreatAdib 6 лет назад
extremly usefull saved my day tomorrow is my final lab mysql exam on database management
@iliyaniliev1079
@iliyaniliev1079 6 лет назад
Sir, you are incredible and you are shining beam of humanity's essence - sharing with others and caring for them! Amazing, amazing video!
@hemendrasahu7943
@hemendrasahu7943 5 лет назад
Good way to teach about many to many relationship between database table. Thank you it helped me
@patriksamju
@patriksamju 6 лет назад
I learn fast on your way in tutoring us on "HOW TO" on stuffs, very easy and concise.
@InfinityEducation3422
@InfinityEducation3422 3 года назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GHeWQPY1DcI.html
@aigbekennethomorodion4026
@aigbekennethomorodion4026 7 лет назад
Great presentation style! Very helpful, thanks.
@jdtaylor1454
@jdtaylor1454 3 года назад
Oh bless you 🙏🏾 May you continue to be a light in the dark places . Tysm
@amirrahman853
@amirrahman853 3 года назад
Just the video i was looking for
@durianjaykin3576
@durianjaykin3576 3 года назад
thank you so much, needed a quick revision and you really helped me out
@mvcypriano
@mvcypriano 7 лет назад
Very good stuff. Thank you.
@cgme7076
@cgme7076 4 года назад
Explained very well. Thank you!
@scotloomi941
@scotloomi941 5 лет назад
Very clear and useful. Thank you.
@navishkakularathna2414
@navishkakularathna2414 4 года назад
This is great. Thank you!
@hisheartsings2742
@hisheartsings2742 2 месяца назад
thanks for this masterpiece i learned a lot.
@sarahmoreels2248
@sarahmoreels2248 5 лет назад
Ty so much! you are great at explaining!
@JimiTip
@JimiTip 6 лет назад
Cool tutorial man really helpful
@almogklinger4525
@almogklinger4525 6 лет назад
great video very helpful and sufficient ! thx !
@victoriacox4313
@victoriacox4313 5 лет назад
SO HELPFUL!!! THANK YOU!!!!
@saadawais8153
@saadawais8153 6 лет назад
Helped a lot thanks.
@aisniper4095
@aisniper4095 2 года назад
Amazing tutorial!
@perfectjuan4245
@perfectjuan4245 5 лет назад
Thank you so much! You help me a lot
@libranajay
@libranajay 6 лет назад
A very nice tutorial.
@edwinaguilar1855
@edwinaguilar1855 3 года назад
Excellent tutorial
@ILIILLLIIILL
@ILIILLLIIILL 7 лет назад
I didn't know that I can make relational database without fields that store the values of foreign table id. Nice video.
@clevertechie
@clevertechie 7 лет назад
Thanks :)
@johnnybegood4756
@johnnybegood4756 5 лет назад
Thanks, Bro! It was really usefull tutorial
@abdulmlaikalomayri727
@abdulmlaikalomayri727 2 года назад
This really useful
@gromitbear9231
@gromitbear9231 3 года назад
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?
@ntulume
@ntulume Год назад
Great stuff clever techie
@clevertechie
@clevertechie Год назад
Thank you!
@evanzhao3887
@evanzhao3887 5 лет назад
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.
@stalinwesley
@stalinwesley 4 года назад
Thanks Great Tutorial .
@monopenguin1375
@monopenguin1375 6 лет назад
Thank you..very helpful:D
@magalyperez9272
@magalyperez9272 6 лет назад
Thank you . Excellent video.
@clevertechie
@clevertechie 6 лет назад
np
@brettaylor2661
@brettaylor2661 5 лет назад
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.
@SpiderLy
@SpiderLy 6 лет назад
Thanks for Tutorial
@michaelchambers5606
@michaelchambers5606 6 лет назад
Thank you!
@joemariebin4874
@joemariebin4874 3 года назад
its so helpful bro i appreciate it thank you for the tutorial Godbless you
@mohsinraza4526
@mohsinraza4526 6 лет назад
your excellent work
@RendernStattGendern
@RendernStattGendern 5 лет назад
great tutorial
@mohamedabdalla844
@mohamedabdalla844 2 года назад
Was useful!!
@HugoRamirezSoto
@HugoRamirezSoto 6 лет назад
Great tutorial, thank you so much!
@brianshaw738
@brianshaw738 4 года назад
Thx. very useful info
@adityatekumalla3578
@adityatekumalla3578 6 лет назад
wonderful ... Thanks a ton :)
@cinemaismywife
@cinemaismywife 3 года назад
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?
@user-hc8zr1tv4h
@user-hc8zr1tv4h 6 лет назад
Good guy!
@ibrahimacobar12
@ibrahimacobar12 7 лет назад
so usefull....thanks a lot
@Krobongo
@Krobongo 3 года назад
Finally a video with a non-indian guy
@angelazeta9448
@angelazeta9448 3 года назад
Thank you for this video :-)
@jamesstark4136
@jamesstark4136 2 года назад
@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.
@sirasidibe3149
@sirasidibe3149 6 лет назад
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 ?
@krish6729
@krish6729 Год назад
Thank you for this lovely lesson. Can this also be done on an Android tablet ?
@DunkusB3ndro
@DunkusB3ndro 6 лет назад
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
@sinas9522
@sinas9522 7 месяцев назад
Thanks
@dayvisonfelipe3172
@dayvisonfelipe3172 6 лет назад
YOU FUCKING SAVED ME RIGHT NOW, BRO. LOVE U!
@joaoemmerich684
@joaoemmerich684 3 года назад
Great!
@treatinet6075
@treatinet6075 Год назад
Thankyou
@medtalks6146
@medtalks6146 4 года назад
thank you
@fritzschreiber552
@fritzschreiber552 6 лет назад
Best Video
@emilianoacuna9705
@emilianoacuna9705 6 лет назад
Can you use mutually exclusive relationships? cant finde them anywhere
@luispereira4495
@luispereira4495 6 лет назад
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??
@viciouz25
@viciouz25 6 лет назад
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
@InfinityEducation3422
@InfinityEducation3422 3 года назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GHeWQPY1DcI.html
@aaron9828
@aaron9828 5 лет назад
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?
@seanleeduncan
@seanleeduncan 2 года назад
Very helpful. Thanks. What did you use to make the initial model diagram?
@clevertechie
@clevertechie 2 года назад
I used workbench and some Photoshop
@varunmj5482
@varunmj5482 6 лет назад
when i try to scrape the data, i get the error in $all_data = array_merge($data,$all_data); that Undefined variable: data
@erikschiegg68
@erikschiegg68 4 года назад
Email adresses and URL can be 255 long, if you choose smaller, some users will not be able to be registered correctly.
@violeta4558
@violeta4558 5 лет назад
How I can setup Timezone on MySql Workbanch server?
@xazmorado2442
@xazmorado2442 6 лет назад
Do you have the example of the insert¿
@bestest43
@bestest43 5 лет назад
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?
@mubirumugerereict5502
@mubirumugerereict5502 6 лет назад
best for me
@misterkoko-code5140
@misterkoko-code5140 7 лет назад
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.
@clevertechie
@clevertechie 7 лет назад
Not sure, haven't played with font sizes yet, I'll let you know if I figure it out.
@ILIILLLIIILL
@ILIILLLIIILL 7 лет назад
Which workbench theme are you using? and is there any way that I can create new model (drawing relations) with existing database?
@clevertechie
@clevertechie 7 лет назад
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.
@ILIILLLIIILL
@ILIILLLIIILL 7 лет назад
Clever Techie Thank you so much! Sorry for my bad English.
@mubarakazeez859
@mubarakazeez859 5 лет назад
Nice presentation. Pls can you help me with the video on how to link MySQL workbench with login page using VS text editor. Thanx.
@mscode-hd8xw
@mscode-hd8xw 5 лет назад
how to call it those tables on the JOIN query?
@sabinamartins2674
@sabinamartins2674 4 года назад
how to download the video of programing with used of mysql
@jamesmakume2630
@jamesmakume2630 3 года назад
If I could subscribe more than once I could.
@clevertechie
@clevertechie Год назад
Glad you liked the video so much :)
@jasperrenaldo7367
@jasperrenaldo7367 4 года назад
Could you help with a python script for the same?
@MrFelipefronte
@MrFelipefronte 4 года назад
GOOD
@sergiyrudenko905
@sergiyrudenko905 6 лет назад
Thanks , great video! give me pls the link for the next video
@emerenuedison2374
@emerenuedison2374 3 года назад
Please how can I get Ur previous video
@adilsoncardoso8391
@adilsoncardoso8391 3 года назад
How do I solve error 1064 on Fw engineering? Please. Have a deadline in 4hours
@cathyb2204
@cathyb2204 7 лет назад
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.
@nobytes2
@nobytes2 7 лет назад
Cathy Bourner You need to run it on a server. Either local server like Apache or your website server. Lookup Xamp or Mamp.
@micko8217
@micko8217 Год назад
why do i have Error 1064: when i try to forward engineering???
@julcrm
@julcrm 4 года назад
What if can't connect with my local database? :(
@skepat9426
@skepat9426 6 лет назад
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!
@odil8484
@odil8484 6 лет назад
"Some movie" Genre : Drama, Fantasy ... that's why
@dotinsideacircle
@dotinsideacircle 6 лет назад
Thanks for the tutorial. Excuse my total noobness but I guess the only reason why you're using phpAdmin to view all of the data is because this tutorial is for the IMDB php script. Why didn't you just confirm the database existed in MySQLWorkbench? It's all there under schemas.
@TheMrGreenMoney
@TheMrGreenMoney 5 лет назад
What is the difference between creating a relationship with a continuous or discontinuous line?
@SupertCZ
@SupertCZ 5 лет назад
Continuous line - Value has to be specified Discontinuous line - Value can be null
@charlieramonesbackingtrack8876
One movie can be directed by one or many directors, one director can direct none, one or many movies. 😎
@KS-fz7hh
@KS-fz7hh 4 года назад
I don't really get why you choose "ID" and then don't explain your choice.
@SciDOCMBC
@SciDOCMBC Год назад
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".
@futurepython6774
@futurepython6774 2 года назад
mysql/django/python新教程:ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-61RE4DZ33oY.html
@richardb8104
@richardb8104 7 лет назад
it won't let me setup the localhost connection
@richardb8104
@richardb8104 7 лет назад
I reinstalled the server and it works!
@Dinerlegacy
@Dinerlegacy 5 лет назад
dev.mysql.com/downloads/shell/ Are you sure you installed my SQL after this tool?
@ciaranlane8676
@ciaranlane8676 5 лет назад
@@richardb8104 How did you reinstall the server?
@Spiceysec
@Spiceysec 3 года назад
unable to connect to local host
@catalintodoran4302
@catalintodoran4302 5 лет назад
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 :)
@isaacalexisrivera3157
@isaacalexisrivera3157 4 года назад
html is a markup language, works only in the client side, php works in the server side
@levchegochev6086
@levchegochev6086 4 года назад
How can i get the script?
@farmerlanglang
@farmerlanglang 6 лет назад
localhost/phpmyadmin/ site cant be reached
Далее
Основы работы MySQL Workbench
47:11
Просмотров 29 тыс.
😍😂❤️ #shorts
00:12
Просмотров 792 тыс.
Как выходим с тройняшками 🙃
00:17
Database Schema
6:20
Просмотров 606 тыс.
Создание базы данных MySQL Workbench
12:55
MySQL Workbench Design Walkthrough
21:16
Просмотров 130 тыс.
How to Generate an ERD in MySQL Workbench
11:43
Просмотров 32 тыс.
Relational Database Concepts
5:25
Просмотров 995 тыс.
Respect 😱🔥 #shorts #respect #viral
0:31
Просмотров 39 млн
Surprised 😳🤩🤩❤️🔥🥳
0:35
Просмотров 14 млн