CODEWITHSUNDEEP
pythonmysqlpython-3.xmysql-pythonmysql-connector
user17388930
user17388930

Reputation:

Insert Data in mysql using python

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

Upvotes: 0

Views: 179

Answers (1)

nbk
nbk

Reputation: 49373

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

Upvotes: 2

Related Questions