sqlite3.OperationalError: near WHERE: syntax error

2024/11/17 3:42:22

I want to update a series of columns Country1, Country2... Country 9 based on a comma delimited string of country names in column Country. I've programmed a single statement to accomplish this task.

cur.execute("\UPDATE t \SET Country1 = returnCountryName(Country,0),\Country2 = returnCountryName(Country,1),\Country3 = returnCountryName(Country,2),\Country4 = returnCountryName(Country,3),\Country5 = returnCountryName(Country,4),\Country6 = returnCountryName(Country,5),\Country7 = returnCountryName(Country,6),\Country8 = returnCountryName(Country,7),\Country9 = returnCountryName(Country,8),\Country10 = returnCountryName(Country,9),\WHERE Country IS NOT NULL\;")

Howerver, I am getting the error

sqlite3.OperationalError: near "WHERE": syntax error
Press any key to continue . . .

Answer

You have to remove the comma from the last assignment:

Country10 = returnCountryName(Country,9),\

See also my answer to your original question

https://en.xdnf.cn/q/118846.html

Related Q&A

If statement not working correctly in Python 3

This is the start of an RPG I am going to make, and It runs smoothly until I try to change the gender by saying yes or any other of the answers that activate the if statement. Is there something I am f…

pymc3 error. AttributeError: module arviz has no attribute geweke [closed]

Closed. This question needs debugging details. It is not currently accepting answers.Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to repro…

how to prevent duplicate text in the output file while using for loop

I have this code which compares a number to a number(what i called item in my code) in the domain range to see if it is already there. If it its then print to the output file if it is not then only pri…

How to replace \\ with \ without raising an EOL error?

I am reading from a file that contains byte data but when I open the file and store the readline data into a variable it stores it in a string with backslash escapes, So when trying to decode that data…

How to find duplicates in pandas dataframe

Editing. Suppose I have the following series in pandas:>>>p 0 0.0 1 0.0 2 0.0 3 0.3 4 0.3 5 0.3 6 0.3 7 0.3 8 1.0 9 1.0 10 1.0 11 0.2 12 0.2 1…

i have error eol while scanning string literal

i dont know what is the problem im junior on python programer what happened on my code i study but i dnt understand this #fungsi coveragedef coverage ():print("[1] Kota Besar)print("[2] Kota…

How to extract specific data from JSON?

I cant seem to extract specific data from JSON which I retrieved from a link. I wrote this code and seems to work fine up to x [print(x) that is] as you can see from the screenshot-1. But, its giving e…

python csv: getting subset

here is a snapshot of my csv:alex 123f 1 harry fwef 2 alex sef 3 alex gsdf 4 alex wf35 6 harry sdfsdf 3i would like to get the subset of this data where the occurrence of a…

Variable within a Variable in Python (3)

My head is probably in the wrong place with this, but I want to put a variable within a variable.My goal for this script is to compare current versions of clients software with current software version…

selenium scraping data using children of elements

Hi im trying to scrape some data from a live stocks website. I want to display the companies name and stock price, %change ect. The details of 25 companies are shown per page, and these details follow …

Latest Q&A