postgre sql使用 %s时务必加引号,即为‘%s’,否则报错
if name == ‘main’:
t="TMRO"
sql="select * from lastftp where enbid = %d and keytype = %s"%(110001,t)
print(selectOperate(sql))
结果:
Traceback (most recent call last):
psycopg2.ProgrammingError: column “tdd” does not exist
LINE 1: …* from lastftp where enbid = 110001 and keytype = TDD-LTE_MR…
^
if name == ‘main’:
t="TMRO"
sql="select * from lastftp where enbid = %d and keytype = '%s'"%(110001,t)
print(selectOperate(sql))
结果:
[(‘test3’, ‘TMRO’, ‘0114123000’, ‘0012’, 110001)]
[Finished in 0.1s]