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/
Xem thêm Bài Viết:
- MDM là gì??? – Làm thế nào để tắt được MDM trên Macbook | Mẹo Vặt Macbook
- Người lao động nghỉ bị trừ lương || Tư vấn luật lao động
- Learn Emmet In 15 Minutes – Double Your HTML Coding Speed
- Giang Hồ Thanh Toán Nhau Trên Phố – Tập 4 – Giang Hồ Bắn Giết Nhau Trên Đường | Big Bang
- Lập trình Android A-Z – Bài 159: Fragment Create and add XML
Thanks Great Tutorial .
Easy to Learn SQL Differential Backup and many more
https://youtu.be/sG3sgLHW5SU
Thankyou
but how to select the fk ?
I don't really get why you choose "ID" and then don't explain your choice.
What if can't connect with my local database? 🙁
Thx. very useful info
I'm taking this as my school project
Explained very well.
Thank you!
How can i get the script?
thank you
Thanks you!
wtfcn this ?
This is great. Thank you!
how to download the video of programing with used of mysql
Thank you so much! You help me a lot
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.
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 🙂
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.
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.
What is the difference between creating a relationship with a continuous or discontinuous line?
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
Thanks man.
too fast at the end
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!!!!
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.
Ty so much! you are great at explaining!
Good way to teach about many to many relationship between database table. Thank you it helped me
great tutorial
Very clear and useful. Thank you.
One movie can be directed by one or many directors, one director can direct none, one or many movies. 😎
how to call it those tables on the JOIN query?
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.
This was super helpful. Is there a way to make changes to tables in MySQL Workbench and sync them back to the database easily?
Man! Too many ads in the video.
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.
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?
That is so awesome! I love that someone created the GUI interface and forward engineer option!
Thanks, Bro! It was really usefull tutorial
60th comment…
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.
great video very helpful and sufficient ! thx !
Helped a lot thanks.
Can you use mutually exclusive relationships? cant finde them anywhere
when i try to scrape the data, i get the error in $all_data = array_merge($data,$all_data); that Undefined variable: data
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.
great explanation sir!