Python MySQL Tutorial - Foreign Keys & Relating Tables

Рет қаралды 81,077

4 жыл бұрын

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.
Playlist: • Python MySQL Tutorial ...
◾◾◾◾◾
💻 Enroll in The Fundamentals of Programming w/ Python
tech-with-tim.teachable.com/p...
📸 Instagram: / tech_with_tim
🌎 Website techwithtim.net
📱 Twitter: / techwithtimm
⭐ Discord: / discord
📝 LinkedIn: / tim-rusci. .
📂 GitHub: github.com/techwithtim
🔊 Podcast: anchor.fm/tech-with-tim
💵 One-Time Donations: www.paypal.com/donate/?token=...
💰 Patreon: / techwithtim
◾◾◾◾◾◾
⚡ 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

Пікірлер: 49

@longnguyenhuy3286 4 жыл бұрын

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

@TechWithTim 4 жыл бұрын

I appreciate the message! And yes I'm planning on many more videos

@reedfelix9254 3 жыл бұрын

a tip : watch movies at kaldrostream. Me and my gf have been using them for watching lots of of movies recently.

@londonkieran2924 3 жыл бұрын

@Reed Felix Yup, I have been using kaldroStream for months myself :)

@michaelrourk24 4 жыл бұрын

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!

@minhtuecung5418 3 жыл бұрын

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

@HA-fq5xc 4 жыл бұрын

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

@alifilali8110 4 жыл бұрын

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

@leonwinkel6084 3 жыл бұрын

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

@jvnganesh4943 4 жыл бұрын

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.

@Kazeumi 3 жыл бұрын

This was very useful, very clearly and succinctly explained.

@khandoor7228 4 жыл бұрын

Tim Great series please keep going!

@kavehmoradkhani8018 2 жыл бұрын

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

@gianniprocida3332 Жыл бұрын

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

@kasyapdharanikota8570 3 жыл бұрын

you are my inspiration , thank your for these videos

@chrisgousset8673 Жыл бұрын

Awesome video as always, thank you!

@okc6075 2 жыл бұрын

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

@devmclovin 3 жыл бұрын

great vid man

@rishikeshpant3060 4 жыл бұрын

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.

@ruarty 2 жыл бұрын

thx for video you helped me make course work

@kabeerkumar4334 4 жыл бұрын

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.

@mbuzifromthehood 3 жыл бұрын

nice video, couldn't find the next video tho where he explains one to many etc

@bogdanmind3271 2 жыл бұрын

Thank you very much!

@RajSingh-gz6mr 2 жыл бұрын

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

@johnhupperts 4 жыл бұрын

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.

@will2see 2 жыл бұрын

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

@gee_rex 2 жыл бұрын

hey Tim i think you make all your videos very easy to understand, well done. ...quick question about this video though, cant I do all that with Xamp??? and maybe you should do a video on that (Xamp)

@vasishtakanthi4231 Жыл бұрын

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

@kickassvideos5469 2 жыл бұрын

Where can i find the follow up video on this one? where you explain how to setup a one to many relation?

@sainco3036 4 жыл бұрын

thanks.

@grrogg Жыл бұрын

How do you get syntax highlighting for the SQL strings?

@photogyulai 9 ай бұрын

"Highlight String Code" extension for vs code, worked for me.

@photogyulai 9 ай бұрын

Sorry i was wrong: it fks up the other syntax highlights

@supersmash6058 2 жыл бұрын

Will this work with sqlite

@chaitanyakamble199 4 жыл бұрын

how come this video does not have like 30k likes

@boyzone5000 3 жыл бұрын

in sqlite isn't auto increment meant to be 'AUTOINCREMENT' without the underscore??

@InfinityBS 5 ай бұрын

i know im 3 years late but hes using MySQL not sqlite

@1r3x58 4 жыл бұрын

I know tkinter,requests,pygame library whats next ? please answer

@afridinaseer 4 жыл бұрын

Great work i think i can fix my confusion where i was getting parents key for the child key through loop to go untill last row of the parent to get the last key and to assign it to the child but i think referencing the parent table will work. If didn't then will come back to ask if you can help me. I will really appreciate thanks

@sathyx 3 жыл бұрын

Content wise good as always but for me it was too rushed.

@ellsonmendesYT 3 жыл бұрын

too difficult for a mortal like me :)

@stickercode 9 ай бұрын

Appreciated though, kinda went lost for the last 5 minutes

@kareemnashaat7505 4 жыл бұрын

Hi tim i need your help to know this line import requests import json import re import threading import urlparse import os import glob Pls help me if you can or explain it in comment❤❤