This tutorial will teach you how to create, add and remove, foreign keys in MySQL. Follow me on social media: Twitter: https://twitter.com/QuentinWatt Facebook: …
Original source
This tutorial will teach you how to create, add and remove, foreign keys in MySQL. Follow me on social media: Twitter: https://twitter.com/QuentinWatt Facebook: …
Original source
28 responses to “MySQL tutorial 18 – Foreign Keys”
i love that fizz on the background
The irony.. i learned all this..
but i still can't think of being told how to actually… fill the tables.
I must've missed it…
kind of hilarious really.
As usual thanks for the series, they are really useful.
i never imagined it would be this easy until i started ur tutorials….thanks for creating this playlist it was really helpful
MySQL workbench is not allowing me to use the field products(product_id) as a foreign key in two separate tables. Is this a restriction inherent to SQL?
An example of a situation where you'd want to remove a foreign key is if you're refactoring your application, and want to drop the table which contained a column which was referenced in the foreign key.
Thank you for that tutorial, I finished it in two days and have a solid understanding of MySql
Thank you for sharing. It is very helpful
I watched all MySQL tutorials and while watching i did write te usefull information on paper, thanks for tutorial
bit in cohesive
Great video but please stop swallowing in the mic..
Good video, but not one video out there showing this on workbench
Following but wondering if it's possible to access your database to practice
Quintin, you are really the best SQL teacher here.. I learned so many things from you that I was not able to in class. Big Thanks to you bro. Keep at it !
Man, it is a pity that it is the last one in the series π
Good tutorial
thank you – great series!
hi
wohooo iam the 108,427 subscriber feeling sad to be that much late but happy to join the Q family
tnkxxxx broooo πππππ
Hallo Quentin, your tutorials are so amaizing bravo!!
soooo, how to link mysql to php ?
i mean how can i get some data from users in html and put em in my database?
the query runs but does not work does it have to be a integer and not a varchar?
η»δΊηε°ζεε¦γηηζ―εΎη¨εΏηθ§ι’εεγεδ½ ε¦δΉ οΌοΌ
I was 60k subscriber!
100,100th subscriberβ
Are you going to do a 100k special?
Hey Quentin, how's it going? I was just wondering if you are able to make some more vlogs of Johannesburg, it is completely understandable if you are not able to, but I would like to see some more, please. And also, are you going to be making an angular series?
what will be the next sir?
Thank you:) But i have a question, when i insert a row and there is a forgein key , i could just insert the plain id( VALUES (0….)) or i need to grab the id from the table that i link to(VALUES(SELECT ID FROM user WHERE ….))? Cuz i dont find any answer on internet