Insert data into specific row using MySQL in Python

Question

I am trying to insert data in a specific row using MYSQL in PYTHON.

I've tried the following code :

sql = "INSERT INTO board (pages) VALUES (%s) WHERE (ASIN) = '" + asinList[x] + "'"
val = (a)
myCurser.execute(sql, val)

However, I got this error :

"

mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%s) WHERE (ASIN) = 'B07KWSRMK1'' "

how to solve it?

Gordon Linoff · Accepted Answer · 2019-05-18 11:46:26Z

1

INSERT does not support WHERE clause with VALUES.

If you really want add a new rows then you should use INSERT.

 sql = "INSERT INTO board (pages) VALUES (%s) '"

You may be looking to update an existing row. In this you should use UPDATE:

sql = "UPDATE  board 
       SET pages = %s
       WHERE ASIN  = %s"

edited May 18, 2019 at 11:46

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

answered May 18, 2019 at 9:39

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

Collectives™ on Stack Overflow

Insert data into specific row using MySQL in 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