Simple Python-Connector program - MySQL error

Question

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

Can you add a print (user_name, user_profile_url,complaint_source_url, message_title, message_content,created_on) — FunkySayu
– FunkySayu, Commented Jul 21, 2015 at 12:31

itzMEonTV · Accepted Answer · 2015-07-21 12:49:00Z

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()

edited Jul 21, 2015 at 12:49

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.

Collectives™ on Stack Overflow

Simple Python-Connector program - MySQL error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related