conn = pyodbc.connect('Driver={SQL Server};'
'Server=DESKTOP-IINBCRCSQLEXPRESS;'
'Database=employees;'
'Trusted_Connection=yes;')
cur = conn.cursor()
cur.execute("select * from Login")
for row in cur:
print(row)
输出为'1','2','3',但我希望输出为1 2 3
所以,
txt = "'1', '2', '3'"
lst=[x.strip()[1:-1] for x in txt.split(",")]
" ".join(lst)
这应该产生(我已经测试过)
'1 2 3'
或者更聪明一点:
txt=txt.replace(",","")
txt=txt.replace("'","")