HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://eepurl.com/-8qtH Donate!: http://bit.ly/DonateCTVM2.
Original source
HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://eepurl.com/-8qtH Donate!: http://bit.ly/DonateCTVM2.
Original source
21 responses to “MySQL Tutorial 4 – Keys”
Bucky's younger brother…..or son? lol
Hey Caleb nice video series. I appreciate you effort and simple methodology to explain concepts in less than 10 minutes per video.
Thanks, very useful videos. Keep it up!
Thank you very much, for the momento I understand almost all. More tomorrow.
thanks for fixing, helpful, take care key 🙂
First of all, you are very handsome and nice guy. Your teaching method is different. You have worked a lot to create effective video tutorials. Your video tutorials are very effective as I can say. Go ahead, Mr. Caleb, the good guy.
A lot of times people explain databse, but they don't show how you actually implement it in code. Lkike if you have some java application, how do you make it do a querie or whatever? I get the cnocepts of database but i dont know how you actually implement it in code.
MySQL InnoDB engine and foreign key (constraint) slows down queries, as long as you don't perform for example banking operations I would avoid them 😉 btw. nice to hear you talking even if I know those things
ok. good so far.
So just to put it in perspective, i.e. Gta, I signed my character up and it has a primary key of 7801 (the 7801st person to sign up), this is all stored in a table. And in another table "Inventory", there would be 7801 as a foreign key, and in another column for example all the weapons I've purchased?
So each table has primary keys right? Or only the table of customers' info has primary keys?
great tutorials! i'm starting a datalogging project from things such as electricity sensors and thing MySQL will be a good database to log the results to.
(also you're hot)
Watch series with autoplay: MySQL Tutorial 1 – What is MySQL @CalebCurry
Donations are greatly needed and appreciated! Click to donate: http://bit.ly/DonateCTVM2
thanks for the videos. looking for a starter tut and the series have been a great help so far. subbed!
So can a username be primary key? It can be incremental when placed in alphabetical order. But it is not a number but a string.
Great videos
continued The intention here is that all orders must be associated with a customer that is already in the CUSTOMER table. To do this, we will place a foreign key in the ORDER table and have it relate to the primary key of the CUSTOMER table. (Wiki search example above.)
I hope you are a teacher or an consultant by trade. You are very talented in sharing your knowledge. Thank you.
Better foreign key example: In the context of relational databases, a foreign key is a referential constraint between two tables.[1]
A foreign key is a field in a relational table that matches a candidate key of another table. The foreign key can be used to cross-reference tables.
For example, say we have two tables, a CUSTOMER table that includes all customer data, and an ORDER table that includes all customer orders.
2 entries…?. I only need 1 entry…
No problem, I'm glad to hear! I Hope to see you make it to the end of the series.
The way you explain things is great. Really easy to follow. Thanks!