• Friday , 20 October 2017

MySQL Tutorial 4 – Keys

Code Canyon



HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://eepurl.com/-8qtH Donate!: http://bit.ly/DonateCTVM2.

Original source

3d Ocean

Related Posts

21 Comments

  1. Sig Shooter
    September 6, 2017 at 05:27

    Bucky's younger brother…..or son? lol

  2. Mao Besoya
    September 6, 2017 at 05:27

    Hey Caleb nice video series. I appreciate you effort and simple methodology to explain concepts in less than 10 minutes per video.

  3. yourpersonalgrowth
    September 6, 2017 at 05:27

    Thanks, very useful videos. Keep it up!

  4. marandominguez
    September 6, 2017 at 05:27

    Thank you very much, for the momento I understand almost all. More tomorrow.

  5. Soldie rKing
    September 6, 2017 at 05:27

    thanks for fixing, helpful, take care key 🙂

  6. Mathew Mitra
    September 6, 2017 at 05:27

    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.

  7. andrew paul
    September 6, 2017 at 05:27

    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.

  8. HerbalLife86
    September 6, 2017 at 05:27

    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

  9. David Barr
    September 6, 2017 at 05:27

    ok. good so far.

  10. JesseThaBest
    September 6, 2017 at 05:27

    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?

  11. Chuyi Jiang
    September 6, 2017 at 05:27

    So each table has primary keys right? Or only the table of customers' info has primary keys?

  12. flamesecureUK
    September 6, 2017 at 05:27

    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)

  13. CalebTheVideoMaker2
    September 6, 2017 at 05:27

    Watch series with autoplay: MySQL Tutorial 1 – What is MySQL @CalebCurry

    Donations are greatly needed and appreciated! Click to donate: http://bit.ly/DonateCTVM2

  14. Thinh Nguyen
    September 6, 2017 at 05:27

    thanks for the videos. looking for a starter tut and the series have been a great help so far. subbed!

  15. Pranshu S Raghuvansh
    September 6, 2017 at 05:27

    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.

  16. Ciprian Grindeanu
    September 6, 2017 at 05:27

    Great videos

  17. Peedge80
    September 6, 2017 at 05:27

    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.

  18. Peedge80
    September 6, 2017 at 05:27

    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.

  19. Esteban Dido
    September 6, 2017 at 05:27

    2 entries…?. I only need 1 entry…

  20. CalebTheVideoMaker2
    September 6, 2017 at 05:27

    No problem, I'm glad to hear! I Hope to see you make it to the end of the series.

  21. JayBenz
    September 6, 2017 at 05:27

    The way you explain things is great. Really easy to follow. Thanks!

Leave A Comment

You must be logged in to post a comment.