AttributeError: 'tuple' object has no attribute 'encode' when inserting data using mysql-connector

Question

The following program collects the users inputs and stores them, then it saves that data to a .csv or emails it to me, then finally it inserts that data into a MySQL database.

I am using mysql.connector for this, however I am getting the error

AttributeError: 'tuple' object has no attribute 'encode'

when the program executes.

Here is the code, I think the problem is to do with the type of data trying to be inserted into the database, but I cannot be sure.

import mysql.connector

# ...

# Connect to MySQL Database and send user_input data to 'user' TABLE.
cnx = mysql.connector.connect(user='root', password='ash123', host='localhost', database='user_data_db')
cursor = cnx.cursor()

query = ("INSERT INTO user (user_id, first_name, last_name, age, postcode,  email_address)"
         "VALUES (%s, %s, %s, %s, %s, %s)", (user_id, firstname, lastname, age, postcode, email)) 

cursor.execute(query)
print("Executed Successfully")

cursor.close()
cnx.close()

vaultah · Accepted Answer · 2016-08-27 01:03:23Z

3

Unless it's of the bytes or bytearray type, cursor.execute expects the first argument (SQL query) to have the encode method. query is a 2-tuple, tuples do not have that method and attempts to access it fail with AttributeError.

You can unpack query, in order to use its elements as positional arguments for cursor.execute:

cursor.execute(*query)
# = cursor.execute("INSERT INTO user (user_id, first_name, last_name, age, postcode, email_address)"
#                  "VALUES (%s, %s, %s, %s, %s, %s)", (user_id, firstname, lastname, age, postcode, email))

edited Aug 27, 2016 at 1:03

answered Jan 23, 2015 at 15:20

vaultah

46.9k12 gold badges120 silver badges145 bronze badges

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

1 Comment

Ashley Redman BSc Over a year ago

Thank you very much, I have made the changes and it works perfectly. Such a small changes makes all the difference. I will look into this in the future! :)

Collectives™ on Stack Overflow

AttributeError: 'tuple' object has no attribute 'encode' when inserting data using mysql-connector

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related