MySQL Tutorial 4 – Keys




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”

  1. 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.

  2. 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.

  3. 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

  4. 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?

  5. 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.

  6. 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.

Leave a Reply