Python MySQL Tutorial - Creating Tables, Inserting & Selecting

Which version of mysql-connector should one use?Because on september 23 it doesn't work. thanks

Excellent video!
I am having trouble with this code. I am getting an error 1064 message (MySQLInterfaceError: You have an error in your SQL syntax;). I cannot find where the error is. Any help will be appreciated. here is the code:

create_employees = """CREATE TABLE Employees (
EmployeeID INT AUTO_INCREMENT PRIMARY KEY,
Name VARCHAR,
Role VARCHAR,
Address VARCHAR,
Contact_Number INT,
Email VARCHAR,
Annual_Salary VARCHAR
);"""

cursor.execute(create_employees)
print("Employees table was successfully created.\n")

is there a difference between using %s, .format() and f-strings?

You saved my hassssssssssssssss 🤕🤕❤❤❤❤

Thanks for your great explanation 🙂

Great tutorial! Helped me with a project!

Where are you writing these commands????

How about dfs to dba and vice versa

is it possible to do this in pycharm community edition?

Excellent as always, Tim!

Very basic. LOVE IT!

Thank you so much bro

Only 1m subs??? you deserve more

How can I make SQL scripts colored like yours please (I'm using PyCharme) !!

can you provide tutorial for Sqlite3?

how do you get that CLEAN syntax highlighting for mysql?

SELECT * FROM Person is only returning the first tuple for me. Not sure why. If I were to use MySQL directly, that'd work as intended

nice work bro...thank u sooo much...👌👌👌👌👍👍👍

Is there any way you could make a quick video explaining how to do this with a Django project? Thank you!

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

Fantastic tutorial, thanks! 👍

This video didn't make any sense. The lines of code written for some reason do not work. Why is this so difficult!?

the way you explain... amazing...

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.

Bro I can't create 2 table in a single prog.
Can u give a small example on how to do it.

Excellent. Thank you

For some reason the commit isn't working for me, I'm not getting errors, but my db is not being updated.

Thank you !! ur help has been helpful

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!

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

For your information a pizza has 2,269 calories, idk what pizzas you eating, but like hand em over

why are we using %s for integer value as well?
%d is used for the integer value.

I'm not getting any errors, but the data isn't going to the database (ClearDB)

Screw this. I want a pizza now.

thanks buddy it helped a lot...

2.35

How can I insert "curdate()"? It says Incorrect date value...

Hi Tim , This video is really good. I'm stuck in one spot. When I tried to create the table I got an error that I have a reference error: weakly referenced object no longer exists. Do you know how to fix this? I've looked everywhere but nothing seems to be working.

you are a genius.

String formatting in MySQL requires a minimum of (%s,%s) otherwise this throws an error. A single (%s) will not work.

Or any compiler

Ur using mysql appa

What software is this please?

very helpful video

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

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!!!

Thankyou tim

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.

hello, I've been following your channel for sometime now. thanks for the uploads and great explanations.

Where did you learn how to code? I am starting out on my own and would like some recommendations if you dont mind! Thanks again!