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
4 жыл бұрын
I can also help you with a hug.
@FacePalmProduxtnsFPP
6 жыл бұрын
That is so awesome! I love that someone created the GUI interface and forward engineer option!
@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.
@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*
@patriksamju
7 жыл бұрын
I learn fast on your way in tutoring us on "HOW TO" on stuffs, very easy and concise.
@InfinityEducation3422
4 жыл бұрын
kzitem.info/news/bejne/qH6bvYWGkmN1ln4
@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
7 жыл бұрын
You're welcome :)
@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.
@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! 😁
@sudsown7258
3 ай бұрын
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.
@GreatAdib
6 жыл бұрын
extremly usefull saved my day tomorrow is my final lab mysql exam on database management
@erikschiegg68
4 жыл бұрын
Email adresses and URL can be 255 long, if you choose smaller, some users will not be able to be registered correctly.
@krish6729
Жыл бұрын
Thank you for this lovely lesson. Can this also be done on an Android tablet ?
@cinemaismywife
4 жыл бұрын
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?
@SciDOCMBC
2 жыл бұрын
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".
@micko8217
Жыл бұрын
why do i have Error 1064: when i try to forward engineering???
@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
@jdtaylor1454
3 жыл бұрын
Oh bless you 🙏🏾 May you continue to be a light in the dark places . Tysm
@adilsoncardoso8391
3 жыл бұрын
How do I solve error 1064 on Fw engineering? Please. Have a deadline in 4hours
@imie5762
6 ай бұрын
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?
@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?
@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!
@KS-fz7hh
4 жыл бұрын
I don't really get why you choose "ID" and then don't explain your choice.
@seanleeduncan
2 жыл бұрын
Very helpful. Thanks. What did you use to make the initial model diagram?
@clevertechie
2 жыл бұрын
I used workbench and some Photoshop
@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
@amirrahman853
3 жыл бұрын
Just the video i was looking for
@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?
@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
7 жыл бұрын
Thanks :)
@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
7 жыл бұрын
Not sure, haven't played with font sizes yet, I'll let you know if I figure it out.
@sirasidibe3149
7 жыл бұрын
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 ?
@emilianoacuna9705
6 жыл бұрын
Can you use mutually exclusive relationships? cant finde them anywhere
@jasperrenaldo7367
4 жыл бұрын
Could you help with a python script for the same?
@emerenuedison2374
3 жыл бұрын
Please how can I get Ur previous video
@Krobongo
4 жыл бұрын
Finally a video with a non-indian guy
@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??
@brettaylor2661
6 жыл бұрын
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.
@julcrm
4 жыл бұрын
What if can't connect with my local database? :(
@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
4 жыл бұрын
kzitem.info/news/bejne/qH6bvYWGkmN1ln4
@sabinamartins2674
5 жыл бұрын
how to download the video of programing with used of mysql
@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
5 жыл бұрын
html is a markup language, works only in the client side, php works in the server side
@TheMrGreenMoney
5 жыл бұрын
What is the difference between creating a relationship with a continuous or discontinuous line?
@SupertCZ
5 жыл бұрын
Continuous line - Value has to be specified Discontinuous line - Value can be null
@ntulume
2 жыл бұрын
Great stuff clever techie
@clevertechie
Жыл бұрын
Thank you!
@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
7 жыл бұрын
Cathy Bourner You need to run it on a server. Either local server like Apache or your website server. Lookup Xamp or Mamp.
@hemendrasahu7943
5 жыл бұрын
Good way to teach about many to many relationship between database table. Thank you it helped me
@bestest43
6 жыл бұрын
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?
@askdrten
Күн бұрын
scrape-imdb.php doesn't work anymore in 2024? is this something to do with the imdb server or my local code? I did create $data = scrape_imdb(2020,2024,1,2); print_r($data); as per the video. gives me Warning: Undefined variable $data in C:\xampp\htdocs\scrape-imdb.php on line 162 Fatal error: Uncaught TypeError: array_merge(): Argument #1 must be of type array, null given in C:\xampp\htdocs\scrape-imdb.php:162 Stack trace: #0 C:\xampp\htdocs\scrape-imdb.php(162): array_merge(NULL, Array) #1 C:\xampp\htdocs\scrape-imdb.php(9): scrape_imdb(2020, 2024, 1, 2) #2 {main} thrown in C:\xampp\htdocs\scrape-imdb.php on line 162
@xazmorado2442
6 жыл бұрын
Do you have the example of the insert¿
@skepat9426
7 жыл бұрын
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
6 жыл бұрын
"Some movie" Genre : Drama, Fantasy ... that's why
@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.
@farmerlanglang
6 жыл бұрын
localhost/phpmyadmin/ site cant be reached
@durianjaykin3576
3 жыл бұрын
thank you so much, needed a quick revision and you really helped me out
@violeta4558
5 жыл бұрын
How I can setup Timezone on MySql Workbanch server?
@mscode-hd8xw
5 жыл бұрын
how to call it those tables on the JOIN query?
@TLOL777
6 ай бұрын
thanks for this masterpiece i learned a lot.
@Spiceysec
3 жыл бұрын
unable to connect to local host
@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
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
7 жыл бұрын
Clever Techie Thank you so much! Sorry for my bad English.
@S1mple0bserver
2 жыл бұрын
Amazing tutorial!
@EdwinSepulvedaLE
7 жыл бұрын
You really explained this course super excellent, thanks.
@levchegochev6086
4 жыл бұрын
How can i get the script?
@jamesmakume2630
4 жыл бұрын
If I could subscribe more than once I could.
@clevertechie
Жыл бұрын
Glad you liked the video so much :)
@cgme7076
4 жыл бұрын
Explained very well. Thank you!
@dayvisonfelipe3172
6 жыл бұрын
YOU FUCKING SAVED ME RIGHT NOW, BRO. LOVE U!
@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.
@aigbekennethomorodion4026
7 жыл бұрын
Great presentation style! Very helpful, thanks.
@edwinaguilar1855
3 жыл бұрын
Excellent tutorial
@navishkakularathna2414
5 жыл бұрын
This is great. Thank you!
@abdulmlaikalomayri727
3 жыл бұрын
This really useful
@almogklinger4525
6 жыл бұрын
great video very helpful and sufficient ! thx !
@sarahmoreels2248
5 жыл бұрын
Ty so much! you are great at explaining!
@saadawais8153
6 жыл бұрын
Helped a lot thanks.
@libranajay
6 жыл бұрын
A very nice tutorial.
@stalinwesley
4 жыл бұрын
Thanks Great Tutorial .
@joemariebin4874
3 жыл бұрын
its so helpful bro i appreciate it thank you for the tutorial Godbless you
@mvcypriano
7 жыл бұрын
Very good stuff. Thank you.
@richardb8104
7 жыл бұрын
it won't let me setup the localhost connection
@richardb8104
7 жыл бұрын
I reinstalled the server and it works!
@Dinerlegacy
6 жыл бұрын
dev.mysql.com/downloads/shell/ Are you sure you installed my SQL after this tool?
@ciaranlane8676
6 жыл бұрын
@@richardb8104 How did you reinstall the server?
@jemoli87
5 жыл бұрын
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.
@charlieramonesbackingtrack8876
5 жыл бұрын
One movie can be directed by one or many directors, one director can direct none, one or many movies. 😎
Пікірлер: 141