Python Forum
Error 1064 (42000) when executing UPDATE SQL
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error 1064 (42000) when executing UPDATE SQL
#1
Good afternoon:

I am trying to run an UPDATE query in SQL from python. I think the statement is correct, but it constantly returns an error. I do not know what to do...

---------------------------------------------------------
UPDATE ps_product_lang SET description = '--', name = 'Ratón óptico Standard USB' WHERE id_product = 278335 AND id_lang = 1;
---------------------------------------------------------
this is the sql i am using


Can somebody help me?

Thank you so much!
Reply


Messages In This Thread
Error 1064 (42000) when executing UPDATE SQL - by gratiszzzz - May-21-2023, 11:12 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Syntax error while executing the Python code in Linux DivAsh 8 1,730 Jul-19-2023, 06:27 PM
Last Post: Lahearle
  error 1102 (42000) incorrect database name 's' Anldra12 4 1,740 Jun-08-2022, 09:00 AM
Last Post: Anldra12
  SSL error while trying to update conda ilango 0 2,206 Nov-04-2021, 08:38 AM
Last Post: ilango
  Eliminating error in Python update-alternatives Led_Zeppelin 2 3,031 Apr-14-2021, 12:49 PM
Last Post: Led_Zeppelin
  Facing error while executing below Python code ramu4651 1 5,793 Jan-26-2021, 06:40 PM
Last Post: ibreeden
Question Python + Google Sheet | Best way to update specific cells in a single Update()? Vokofe 1 2,724 Dec-16-2020, 05:26 AM
Last Post: Vokofe
  Error when executing pytesseract to get the text from image bvdinesh 3 18,025 Oct-19-2019, 05:01 PM
Last Post: cwco00
  pymysql.err.ProgrammingError : 1064 You have an error in your SQL syntax pradeepkumarbe 1 12,620 Jul-01-2019, 08:05 AM
Last Post: pradeepkumarbe
  Error executing Jupyter command 'notebook': [Errno 'jupyter-notebook' not found] 2 Newtopython123 10 31,399 Apr-25-2019, 07:30 AM
Last Post: banu0395
  Cannot update or install anything with pip, SSL error nickystixx45 6 179,482 Mar-26-2019, 03:42 AM
Last Post: nickystixx45

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020