Python sql problem, substitute in sql

period = "573"
SHYA= sqldf("select PPMONTH, REGION, WEARSEG, sum(uncal_value) as uncal_value \
           from Ftable where region in ("Shanghai") and WEARSEG in ("Men","Women")\
           and PPMONTH in (period) group by PPMONTH,WEARSEG")
           
sql in (period") 

PandaSQLException: (sqlite3.OperationalError) no such column: period [SQL: "select PPMONTH, REGION, WEARSEG, sum(uncal_value) as uncal_value-sharp-sharp-sharp

sources of topics and their own ideas

related codes

/ / Please paste the code text below (do not replace the code with pictures)

what result do you expect? What is the error message actually seen?

Python sql

Jun.28,2022

Brother, the error report says:
no such column: period
means there is no such column.
do you not have a definition of period ? Is
or period a string? You didn't use double quotation marks?
or you can post the data. Let me see

SQL cannot write period directly. It should be converted to the value string corresponding to period


SQLsqlperiodinlist
sql='select PPMONTH, REGION, WEARSEG, sum(uncal_value) as uncal_value \
           from Ftable where region in ("Shanghai") and WEARSEG in ("Men","Women")\
           and PPMONTH in ({}) group by PPMONTH,WEARSEG'.format(','.join(['%s' for _ in period]))
cursor.execute(sql, period)


										
												Previous: Vue-cli3 set up an alias, but it didn't work. I don't know what went wrong.
												                		Next: CORS is set on the server, but without console in chrome, it still cannot be loaded, and the console can be loaded
                							
					
						
					
															
						
														
								Sqlite3 error message in Python. InterfaceError
								
 sqlite3 error message in Python:   
 the code is as follows: 
df = pandas.DataFrame(newsdetail)
df.to_excel(  news1.xls  )
import sqlite3
with sqlite3.connect(  news.sqlite  ) as db:
    df.to_sql(  news  ,con = db)
    df2 = pandas.read_sql_query(  SEL...
								
									
																														Python
																				sqlite3
																			
									
										Feb.28,2021
									
								
							
														
								What does the MySQL collation mean?
								
 I have found many articles on utf8_unicode_ci, utf8_general_ci and utf8_bin collation on the Internet, and I generally know that ci is case ignore, etc., but I didn  t mention what other collations mean   .
 what does the utf8mb4_polish_ci collation her...
								
									
																														Java
																				python
																				sql
																				mysql
																				php
																			
									
										Mar.10,2021
									
								
							
														
								Case insensitivity of like query in MySQL5.7
								 for example, I like  % R% answer, the query results include not only R, but also r, which is not what I want, I want to be case-sensitive. I guess it has something to do with the proofreading rules of the table. My table uses utf8mb4 encoding, and the pr...
								
									
																														Mysql
																				mysql-character-set
																				python
																				sqlalchemy
																			
									
										Mar.11,2021
									
								
							
														
								How to do exclude query by python sqlalchemy
								
The  database is mysql, checked the document and found no exclude, only an except_.  if my table is called table_a, and has a status field, if it is a single field, you can use! = to exclude,  what should I say if it is a scope? For example, if you have ...
								
									
																														Python
																				sqlalchemy
																			
									
										Mar.15,2021
									
								
							
														
								Sqlalchemy query data, sort according to the data in the field (Chinese) to Pinyin (ascending order)
								
 1.sqlalchemy query data, sort according to the data in the field (Chinese) to Pinyin (ascending order)  2. It is known that there are func.convert and sql.func.CONVERT methods in sqlalchemy, and the import method is .
from sqlalchemy import func
from sq...
								
									
																														Sort-positive-order-reverse-order
																				Hanyu-Pinyin
																				Chinese
																				python
																				sqlalchemy
																			
									
										Mar.24,2021
									
								
							
														
								Should the inner join query be done directly from the database or should it be queried in two stages?
								
 here  s the problem. For a detailed description, please see below. 

 how should inner join be used compared with separate queries? should inner join be used or should it be considered on a case-by-case basis? 
 when I have the above doubts, is there an...
								
									
																														Python
																				sqlalchemy
																				sql
																			
									
										Oct.16,2021
									
								
							
														
								How does sqlachemy do the following fuzzy query?
								
 A field in the database table is an interval field in json format, such as [100,200]. How to query the data in the table field interval according to the specified number such as 167?  table.query.filter. First 
 find a solution 
...
								
									
																														Python
																				sqlalchemy
																			
									
										Jul.15,2022


				
					
						
	
						
		css
		mysql
		arrays
		josn
		react
		html
		typescript
		webpack
		npm
		sass
		R
		objective-c
		.net
		sql-server
		jquery
		python-3.x
		angularjs
		django
		angular
		excel
		regex
		iphone
		ajax
		linux
		xml
		pandas
		vba
		spring
		database
		wordpress
		string
		wpf
		xcode
		windows
		bash
		postgresql
		oracle
		multithreading
		eclipse
		list
		firebase
		algorithm
		macos
		forms
		image
		scala
		visual-studio
		azure
		bootstrap
		spring-boot
		react-native
		python-2.7
		docker
		performance
		function
		winforms
		matlab
		powershell
		apache
		dataframe
		api
		sqlite
		numpy
		rest
		shell
		selenium
		flutter
		dart
		maven
		loops
		qt
		swing
		android-studio
		csv
		express
		file
		class
		tensorflow
		sorting
		codeigniter
		perl
	
						MySQL Query :  SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5 
 MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3175c-2bdac.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") 
 MySQL Errno : 1021 
 Message :  Disk full (/tmp/#sql-temptable-64f5-1b3175c-2bdac.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") 
Need Help?