Upgrade your Clever Techie learning experience:

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:

““““““““““““““““““““““““““““““““““““““““““““““`

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.

Nguồn: https://codeigniterbrasil.com

Xem thêm bài viết khác: https://codeigniterbrasil.com/lap-trinh-php/

49 Comments

stalin wesley

April 30, 2020

Thanks Great Tutorial .

Reply

LEO A beautiful mind

April 30, 2020

Easy to Learn SQL Differential Backup and many more
https://youtu.be/sG3sgLHW5SU

Reply

Dhea Fiky Fatchatur Rizky

April 30, 2020

Thankyou

Reply

Tamal Das

April 30, 2020

but how to select the fk ?

Reply

Syllable Skill

April 30, 2020

I don't really get why you choose "ID" and then don't explain your choice.

Reply

Julio

April 30, 2020

What if can't connect with my local database? 🙁

Reply

Brian Shaw

April 30, 2020

Thx. very useful info

Reply

Harii

April 30, 2020

I'm taking this as my school project

Reply

CGMe

April 30, 2020

Explained very well.
Thank you!

Reply

Levche Gochev

April 30, 2020

How can i get the script?

Reply

med talks

April 30, 2020

thank you

Reply

Griffon Wolfdale

April 30, 2020

Thanks you!

Reply

Ivan Booba

April 30, 2020

wtfcn this ?

Reply

Navishka Kularathna

April 30, 2020

This is great. Thank you!

Reply

sabina martins

April 30, 2020

how to download the video of programing with used of mysql

Reply

Perfect Juan

April 30, 2020

Thank you so much! You help me a lot

Reply

Zhao Ningduo

April 30, 2020

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.

Reply

Cata Molecula

April 30, 2020

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 🙂

Reply

Violeta Stanojkovska

April 30, 2020

How I can setup Timezone on MySql Workbanch server?

Reply

Mubarak Azeez

April 30, 2020

Nice presentation.
Pls can you help me with the video on how to link MySQL workbench with login page using VS text editor.
Thanx.

Reply

Alex L

April 30, 2020

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.

Reply

Andrew

April 30, 2020

What is the difference between creating a relationship with a continuous or discontinuous line?

Reply

jimbo

April 30, 2020

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

Reply

EduCode Cognize

April 30, 2020

Thanks man.

Reply

Lydia Giwa

April 30, 2020

too fast at the end

Reply

Aaron

April 30, 2020

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?

Reply

Victoria Cox

April 30, 2020

SO HELPFUL!!! THANK YOU!!!!

Reply

Jemoli

April 30, 2020

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.

Reply

lina verhaegen

April 30, 2020

Ty so much! you are great at explaining!

Reply

Hemendra Sahu

April 30, 2020

Good way to teach about many to many relationship between database table. Thank you it helped me

Reply

Rendern statt Gendern

April 30, 2020

great tutorial

Reply

Scot Loomi

April 30, 2020

Very clear and useful. Thank you.

Reply

Charlie Ramone's Backing Tracks

April 30, 2020

One movie can be directed by one or many directors, one director can direct none, one or many movies. 😎

Reply

ms. code

April 30, 2020

how to call it those tables on the JOIN query?

Reply

Ms U

April 30, 2020

You're better than my professor; mind you I pay tuition and he doesn't teach me what you are teaching me. I question Education in 2018, because Youtube is doing it for FREE.

Reply

Wisconsin Woodsman

April 30, 2020

This was super helpful. Is there a way to make changes to tables in MySQL Workbench and sync them back to the database easily?

Reply

Siwon Lee

April 30, 2020

Man! Too many ads in the video.

Reply

Bret Taylor

April 30, 2020

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.

Reply

nihat nihat

April 30, 2020

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?

Reply

FacePalmProductions

April 30, 2020

That is so awesome! I love that someone created the GUI interface and forward engineer option!

Reply

JohnnyBeGood I WoT

April 30, 2020

Thanks, Bro! It was really usefull tutorial

Reply

Rova TK

April 30, 2020

60th comment…

Reply

imagic5

April 30, 2020

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.

Reply

Almog klinger

April 30, 2020

great video very helpful and sufficient ! thx !

Reply

saad awais

April 30, 2020

Helped a lot thanks.

Reply

Emiliano acuña

April 30, 2020

Can you use mutually exclusive relationships? cant finde them anywhere

Reply

varun mj

April 30, 2020

when i try to scrape the data, i get the error in $all_data = array_merge($data,$all_data); that Undefined variable: data

Reply

HoneyChai

April 30, 2020

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.

Reply

Tapas Kumar Kalita

April 30, 2020

great explanation sir!

Reply

Leave a Reply