I'm trying to use connector python for inserting records into MySQL
I'm unable to understand why i'm getting
ProgrammingError: Failed processing format-parameters; Python 'list' cannot be converted to a MySQL type
This is my simple program
import mysql.connector
#All variables like user_name etc. are initialized
cnx = mysql.connector.connect(user='root',password='password',database='consumer')
curA = cnx.cursor(buffered=True)
insert_query = "INSERT INTO sno_social_listener( user_name, user_profile_url, message_url, message_title, message_content, created_on ) VALUES ('%s', '%s', '%s', '%s', '%s', '%s')"
curA.execute(insert_query,(user_name, user_profile_url,complaint_source_url, message_title, message_content,created_on))
Prashant Srivastav
1,75317 silver badges28 bronze badges
asked Jul 21, 2015 at 12:25
wolfgang
7,88914 gold badges49 silver badges72 bronze badges
1 Answer 1
This should work.
curA.execute(insert_query %(user_name, user_profile_url,complaint_source_url, message_title, message_content,created_on))
Also at end
cnx.commit()
answered Jul 21, 2015 at 12:42
itzMEonTV
20.4k4 gold badges44 silver badges53 bronze badges
Sign up to request clarification or add additional context in comments.
Comments
default
print (user_name, user_profile_url,complaint_source_url, message_title, message_content,created_on)