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






False


Django, Why does the system automatically generate an empty session? every time the request is made?


Use python to convert dict1 to dict2, in the example. I tried for a long time but couldn't find a solution.


How to self-start the php-fpm service when building a LNMP environment with docker?


Can an array in react state be bound to a dom state using an element in the array?


Wechat browser version 6.6.5 cannot prevent the springback of pull-up and drop-down to the top under ios system.


In express+hbs, how do you define the routed data as a variable on the page?


How to use symbol reference of Iconfont in dva


How to elegantly add data to JSON objects?


Using node to build video streaming server


The proportional width of the echarts graph is inconsistent.


React uses axios to call the background data. After success, how to jump to the page based on the returned value?


I don't understand what a linux command means. Please explain it.


Vue introduces multiple components in vue-router by nesting named views, and does not refresh the same reference in other pages.


Running nodejs reports fewer errors ")"



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



Js implements a (3) (4) (4) = 48


How to write this vim statement


Frequent calls to spring cloud feign failed


How do I make ALSA playback available in docker?


Nginx error failed (21: Is a directory)




© 2021 CodesHelper


Advertising
Contact us
About us


Menu