I'm using an INSERT query to insert in mysql table, there's an error in my syntax

Question

x = self.npprocess_PTE.text()
    y = 123
    if len(self.npprocess_PTE.text()) == 0:
       print("yes") 
    else:
       model = QtGui.QStandardItemModel()
       self.npprocessview_LV.setModel(model)
       z = model.rowCount()
       z = z + 1
       a = str(z)+'_Process'
       b = "INSERT INTO new_part_info(%s) VALUES(%s) WHERE Part_ID = %s"
       c = (z, x, y)
       mycursor.execute(b, c)
       mydb.commit()

The error i am getting:u have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1) VALUES('wb') WHERE Part_ID = 123' at line 1

insert statement does not accept where condition,remove the where condition and try — Ashok Sri, Aug 29 '20 at 08:54
You can't use where with insert . See more here : https://stackoverflow.com/a/485062/7867026 — omn_1, Aug 29 '20 at 09:26

score 1 · Answer 1 · answered Aug 29 '20 at 09:39

There are two errors that I can see in your insert query:

As others pointed out, insert statement does not have a where clause. Either you need to get rid of it, or you need to change the insert into an update. However, this is not the error that causes the error message.
You use z variable as the name of the column for the insert. z is a number. As mysql manual on object identifiers says:

Identifiers may begin with a digit but unless quoted may not consist solely of digits.

So, you need to quote the value in z:

w = '`' + str(z) + '`'

and then use w insted of z when executing the insert. Alternatively, you need to use a variable instead of z, since it is created as:

a = str(z)+'_Process'

It depends on the name of the columns within your table, really.

Thanks a lot @Shadow. Cleared all my doubts – Santosh Naidu Aug 29 '20 at 09:54 — Santosh Naidu, Aug 29 '20 at 09:54

I'm using an INSERT query to insert in mysql table, there's an error in my syntax

1 Answers1