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
#5
That is weird, everything seems to be correct.
Perhaps you should not use the semicolon ( ; ) at the end. The semicolon is primarily used as a statement terminator in client mode. I think you do not need it in this case because the string just ends which is a clear ending of the query.
Reply


Messages In This Thread
RE: Error 1064 (42000) when executing UPDATE SQL - by ibreeden - May-22-2023, 08:46 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Syntax error while executing the Python code in Linux DivAsh 8 1,887 Jul-19-2023, 06:27 PM
Last Post: Lahearle
  error 1102 (42000) incorrect database name 's' Anldra12 4 1,783 Jun-08-2022, 09:00 AM
Last Post: Anldra12
  SSL error while trying to update conda ilango 0 2,239 Nov-04-2021, 08:38 AM
Last Post: ilango
  Eliminating error in Python update-alternatives Led_Zeppelin 2 3,080 Apr-14-2021, 12:49 PM
Last Post: Led_Zeppelin
  Facing error while executing below Python code ramu4651 1 5,865 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,780 Dec-16-2020, 05:26 AM
Last Post: Vokofe
  Error when executing pytesseract to get the text from image bvdinesh 3 18,163 Oct-19-2019, 05:01 PM
Last Post: cwco00
  pymysql.err.ProgrammingError : 1064 You have an error in your SQL syntax pradeepkumarbe 1 12,774 Jul-01-2019, 08:05 AM
Last Post: pradeepkumarbe
  Error executing Jupyter command 'notebook': [Errno 'jupyter-notebook' not found] 2 Newtopython123 10 31,533 Apr-25-2019, 07:30 AM
Last Post: banu0395
  Cannot update or install anything with pip, SSL error nickystixx45 6 180,917 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