wolfgang
wolfgang

Reputation: 7819

Simple Python-Connector program - MySQL error

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

Upvotes: 1

Views: 869

Answers (1)

itzMEonTV
itzMEonTV

Reputation: 20369

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

Upvotes: 1

Related Questions