Python loading data into MySQL: AttributeError: 'tuple' object has no attribute 'encode'

Question

I know this has been discussed a couple of times but following the suggestions provided still did not solve my problem.
I tried to reproduce a youtube tutorial on updating a table:

Code: Part1:

cursor.execute("CREATE DATABASE testdab")
cursor.execute("CREATE TABLE users (name VARCHAR(255), email VARCHAR(255), age INTEGER(10), user_id INTEGER AUTO_INCREMENT PRIMARY KEY)")

Part2:

insert_query = "INSERT INTO users (name, email, age) VALUES (%s, %s, %s)",
record1 = ("Peter", "[email protected]", 30)
cursor.execute(insert_query, record1)

The table is successfully created, but Part2 throws error message: AttributeError: 'tuple' object has no attribute 'encode'

Anyone having an idea what's going wrong here? Many thanks, Thomas

The extras comma at the end of the line creates a tuple.

Klaus D.
– Klaus D.

2021-10-10 12:38:36 +00:00
Commented Oct 10, 2021 at 12:38 — Klaus D.
– Klaus D., Commented Oct 10, 2021 at 12:38
Following what suggestions? Which YouTube video?

OneCricketeer
– OneCricketeer

2021-10-10 13:12:40 +00:00
Commented Oct 10, 2021 at 13:12 — OneCricketeer
– OneCricketeer, Commented Oct 10, 2021 at 13:12

Aazerra · Accepted Answer · 2021-10-10 13:10:21Z

0

you have a syntax problem at end of line after query change
insert_query = "INSERT INTO users (name, email, age) VALUES (%s, %s, %s)",
to
insert_query = "INSERT INTO users (name, email, age) VALUES (%s, %s, %s)"
that comma makes insert_query a tuple and it cause the problem
because you have to give cursor.execute() a string at first argument and a tuple in second argument

answered Oct 10, 2021 at 13:10

Aazerra

1639 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thomas Over a year ago

Hi Aazerra, many thanks for your help and the explanation. It works!

Collectives™ on Stack Overflow

Python loading data into MySQL: AttributeError: 'tuple' object has no attribute 'encode'

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related