Error 1064 (42000) when executing UPDATE SQL

Thread Rating:

Thread Modes

Error 1064 (42000) when executing UPDATE SQL

buran

Posts: 8,093

Threads: 154

Joined: Sep 2016

Reputation: 582

May-22-2023, 02:38 PM

You shouldn't be using string concatenation to construct SQL statements

If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Messages In This Thread

RE: Error 1064 (42000) when executing UPDATE SQL - by buran - May-22-2023, 02:38 PM

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

Users browsing this thread: 1 Guest(s)