Python MySQL Tutorial - Creating Tables, Inserting & Selecting

This video discusses how to create tables, insert data and select information from a MySQL database with python. It will show how to insert data into a MySQL database, Select and show the information.

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

◾◾◾◾◾◾

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

Tags:
- Tech With Tim
- Python Tutorials
- MySQL Python Tutorial
- Python MySQL Tutorial
- Python MySQL Connector
- SQL Python

#Python #PythonMySQL #SQL

[arielmaritano]

I've been watching your videos for a while now, and I've learnt a ton from them. I can't thank you enough! 🙏🏻

[oscargarciahinde]

I'm getting into SQL after neglecting it for years (didn't really need it in my job as an academic researcher) and your tutorials got me up and running in no time. Cheers mate!

[cusematt]

TIM, I used to think you weren't the greatest at explaining things and spoke a bit too generally. But I think I was absolutely wrong and just needed a slightly better base in computer science to follow along. Your videos are mastery (this series and the one on GIT I think in particular). Keep up the great work!

[allegra]

tim you have no idea how much you've saved me with your videos, THANK YOU SO SO SO MUCH

[jj]

absolute great tutorial! so simple and easy to understand! Could you number your videos in the playlist? Might make it easier for people to follow along

[Atheawesome]

Hey Tim! I’ve recently downloaded sublime text and was having issues installing the packages. I’ve checked your uploads and couldn’t find any video on your channel having to do with this subject. I’m certain that I’m not the only one who would be interested in seeing this kind of content.

Nevertheless, keep up the great work and thank you for the educational content!

[thilokeshjain]

I thought it would be very complicated but thanks to you sir feel like I can master this.
Thanks a lot 👍.

[shreyasreedhar]

this is very helpful, .. just one thing: at 13:23, i get three such rows

[StraitBizness]

Thanks for the videos on this. It helped me out quite a bit with linking up mySQL and Python for a project I am working on.

[darnellhill]

Video super helpful!!! I am using the pymysql library, and I could not figure out why my inserts weren't reflecting on my MySQL DB.... I forgot to commit the changes. I made use of the autocommit expression. Thanks!!!

[TheShadyStudios]

you’re choosing the best things to work on m8 thank you

[pedrotorres]

Hi Tim, I have been trying to replicate your tutorial, however whwnever i run mycursor.execute("DESCRIBE Person") or mycursor.execute("SELECT * FROM Person") it doesn´t seem to store anything in my cursor in fact if i try to fetch it it sends an error saying there is nothing to fetch... Any ideas what might be happening (I already checked and the data base with the table and the info are created).

[rediscover.themystery]

I really love you brother. I feel comfortable when I heard you. Best explanation...

[caolanmaguire]

Great tutorial! Helped me with a project!

[sebastiengagneux]

Hello TIm! Your videos are very helpful in my daily work. Thanks.
There is one topic that I am sure you can answer and will be very usefull for the community (and me as well :) ). it is about reading data from SQL in GO. Ex: I cannot find any answer about using the join method in sql for reading 2 tables, but in GOLANG. always based on 1 table.

[jamesgoforth]

13:24 my print statement after cursor is not executing only output is a mysql command prompt, I put a print statement before mycursor is initialized, and that one prints

[Alan-ygwc]

Hi Tim, what if I want to pass in a list with 2 elements with a name and age instead. How would that change the code? BTW I love your videos!

[Sam-tgii]

If I am doing multiprocessing and workers are writing rows to the same table concurrently, d I need to initiate cursor for each worker?

[kailashrathod]

Make different video where you can just explain sql querries(in oracle or something like that) and then continue this series so that it will be easier for the people with no database knowlege that how querries actually works! Great video though!!!

[SatishKumar-mnbi]

nice guidance by you. Hey I am also learning python for fun!