Python MySQL Tutorial - Foreign Keys & Relating Tables

This python MySQL tutorial will cover how to create foreign keys in SQL and how to relate tables together. Foreign keys are simply a way to relate two tables together through having the same column values of one table stored in another.

◾◾◾◾◾
💻 Enroll in The Fundamentals of Programming w/ Python

◾◾◾◾◾◾

⚡ Please leave a LIKE and SUBSCRIBE for more content! ⚡


Tags:
- Tech With Tim
- Python Tutorials
- Python MySQL Tutorial
- MySQL Tutorial Python
- Foreign Keys Python MySQL
- Foreign Keys MySQL
- SQL Foreign Keys

#Python #MySQL #SQL

[longnguyenhuy]

just want to drop a casual appreciation message here. I really love the content and the clear explanation. I really hope that you will continue producing videos like this in the future

[HA-fqxc]

From Saudi arabia I send a huge appreciation for you. Keep up the good work.

[minhtuecung]

I came across your videos under the section "Recommendations" from YouTube. Hate to say this, but often, your 15-minute videos are even better than my whole uni lecture!

[michaelrourk]

Just commenting to say that you started this series around the time I started taking my database management class and I will ABSOLUTELY be binge-watching them before my next exam. So thanks for that!

[alifilali]

Useful tutorial, simple explanation
Keep going
And Tank you for this tutorials

[okc]

Hi Tim, I apprecite your effort to educate us and I'm really greatful for it. If you can also show how to connect two tables where the second table has many rows for the first table as you explained in the second example, it would be great. Thank you very much sir

[leonwinkel]

awesome work, thanks a lot tim !! You are helping me to built up a startup and get closer to my dreams :))

[gianniprocida]

Tim, I love your content. Thank you very much ❤️

[Kazeumi]

This was very useful, very clearly and succinctly explained.

[kasyapdharanikota]

you are my inspiration, thank your for these videos

[RajSingh-gzmr]

Nyc vid, BTW I am highschool student. Loved ur all vids about programming.

[johnhupperts]

Yo Tim, know you're a Linux guy, but pretty much everyone who isn't a programmer uses Windows at work. PyWin32 seems like a super powerful package, but there really isn't much video material on it online, so I have to go off the docs without examples. Could be a cool video for the future.

[jvnganesh]

thank you very much for taking the time and making this video. this really helped me out with my basics and made my coding knowledge much better. I really appreciate this work and hope you continue to keep making such videos cause I really need the help of such videos.

[rishikeshpant]

Just fantastic. Very clear, easy to understand and friendly atmosphere. But how do I go ahead ? Please let me know how I go to next chapter. Of course with the 1 to many sql files.

[kabeerkumar]

Wow man excellent explanation and it's ok you screwed up a little bit in the end... It was kinda funny actually, but doesnt make any difference to the entire video... Thanks so much bro for such an informative video! Please keep it up.

[vasishtakanthi]

Hi Tim! Thank you very much for you videos on MySQL! I've learned a lot from your videos and have started making my own databases for my ongoing project.

I have one question regarding the IDs. As it happened in 15:09, because you forgot to commit the db, the IDs did not get saved properly, and afterwards, when executing the commit, you were able to align the tables with the correct ids (starting from 4) . In the event that a commit hasn't been made, is there a way to remove those uncommitted entries, and recount the ids from 1 with the committed entries? I do kind of think it wouldn't matter much on which number it would start, since the tables are linked with the corresponding ID, but it would great to know if there's the option to remove the entries and recount

[grrogg]

How do you get syntax highlighting for the SQL strings?

[ruarty]

thx for video you helped me make course work

[kavehmoradkhani]

Many of your tutorials are excellent ❤️
Do not be tired.
If possible, do a great tutorial on object detection in deep learning with Pytorch.

[willsee]

Isn't the "executemany" faster than the for loop when dealing with large inserts?