Python Forum
pymysql.err.ProgrammingError : 1064 You have an error in your SQL syntax
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
pymysql.err.ProgrammingError : 1064 You have an error in your SQL syntax
#2
Such a silly mistake I have made

Before

sql_format = "INSERT INTO " + database_name + "." + l_filename + "(" + f_str + ")" 
I changed this to

f'INSERT INTO {l_filename} ({f_str}) VALUES ({place_holder})'

In my question from line 21 to 35 is a wrong way of formatting SQL query. That caused the issue, hope this might help someone.
Reply


Messages In This Thread
RE: pymysql.err.ProgrammingError : 1064 You have an error in your SQL syntax - by pradeepkumarbe - Jul-01-2019, 08:05 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  is this really a syntax error? Skaperen 4 336 May-25-2024, 07:31 AM
Last Post: snippsat
  World Clock syntax error OscarBoots 1 300 May-03-2024, 05:20 AM
Last Post: snippsat
  Syntax error for "root = Tk()" dlwaddel 15 1,543 Jan-29-2024, 12:07 AM
Last Post: dlwaddel
Photo SYNTAX ERROR Yannko 3 539 Jan-19-2024, 01:20 PM
Last Post: rob101
  Syntax error while executing the Python code in Linux DivAsh 8 1,889 Jul-19-2023, 06:27 PM
Last Post: Lahearle
  Code is returning the incorrect values. syntax error 007sonic 6 1,400 Jun-19-2023, 03:35 AM
Last Post: 007sonic
  Error 1064 (42000) when executing UPDATE SQL gratiszzzz 7 1,664 May-22-2023, 02:38 PM
Last Post: buran
  syntax error question - string mgallotti 5 1,456 Feb-03-2023, 05:10 PM
Last Post: mgallotti
  Syntax error? I don't see it KenHorse 4 1,415 Jan-15-2023, 07:49 PM
Last Post: Gribouillis
  Syntax error tibbj001 2 1,019 Dec-05-2022, 06:38 PM
Last Post: deanhystad

Forum Jump:

User Panel Messages

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