Insert Data in mysql using python

Question

import mysql.connector
mydb = mysql.connector.connect(
  host="10.0.72.17",
  user="admin",
  passwd="1qaz!QAZ",
  database="test"
)
mycursor = mydb.cursor()


sql = "INSERT INTO biage(kompaniis_saxeli) VALUES (%s)"
val = ('bane')
mycursor.execute(sql, val)
mycursor = mydb.cursor()

mydb.commit()

This is my python code , and i create column

kompaniis_saxeli varchar(225)

but when i try to run this code there is error

 raise ValueError("Could not process parameters")
ValueError: Could not process parameters

In Python, ('bane') is the same as 'bane', thus you're providing a string. You need to provide a tuple as the argument, and if you have only one value to pass, you can use val = ('bane',) (note the comma after the first element). — Nuno Mariz
– Nuno Mariz, Commented Nov 23, 2021 at 9:25

nbk · Accepted Answer · 2021-11-15 14:52:58Z

2

The python driver needs at least a 2 dimensional list for values

So use:

import mysql.connector
mydb = mysql.connector.connect(
  host="10.0.72.17",
  user="admin",
  passwd="1qaz!QAZ",
  database="test"
)
mycursor = mydb.cursor()


sql = "INSERT INTO biage(kompaniis_saxeli) VALUES (%s)"
val = ('bane',)
mycursor.execute(sql, val)
mycursor = mydb.cursor()

mydb.commit()

answered Nov 15, 2021 at 14:52

nbk

49.6k8 gold badges32 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

Insert Data in mysql using python

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