Insert into MySQL table with Python [duplicate]

Question

I am trying to insert basic data into my MySQL table without any success yet I'm using basic tutorials as demos.

mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%s)' at line 1

My MySQL

CREATE TABLE awesome (
id int NOT NULL AUTO_INCREMENT,
test varchar(50),
PRIMARY KEY (id)
);

My Python code

import mysql.connector

mydb = mysql.connector.connect(
host="localhost",
user="root",
passwd="pass",
database="db"
)

mycursor = mydb.cursor()

sql = "INSERT INTO awesome (test) VALUES (%s)"
val = ("Highway 21")
mycursor.execute(sql, val)

mydb.commit()

print(mycursor.rowcount, "record inserted.")

That would add %s into the database, I need it to add the variable val, Highway 21. — Blueprov
– Blueprov, Commented Jan 27, 2019 at 20:43
Use val = ("Highway 21",). Note the comma; it makes the right-hand side a tuple with one item inside. Without the comma, Python interprets the right-hand side as a string -- it just evaluates the expression inside the parentheses as a string. — unutbu
– unutbu, Commented Jan 27, 2019 at 21:00
Related: Python MySQL Connector database query with %s fails — unutbu
– unutbu, Commented Jan 27, 2019 at 22:10

Rahul Soshte · Accepted Answer · 2019-02-24 17:22:03Z

2

Yes the problem arises when there is only 1 argument in val tuple. Use

val=("Highway 21",)

Note the comma at the end.

answered Feb 24, 2019 at 17:22

Rahul Soshte

1,14811 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Insert into MySQL table with Python [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related