_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
FrontPage › DB一危一所鍵
|
|
[edit]
3 pyodbc: 蠏谿 覯 #Windows OS ODBC誤 讌 . 蠏碁 蟯 り 螳覃 蟆. Windows OS ODBC誤 る conn = pyodbc.connect(r'DSN=mynewdsn;UID=user;PWD=password') 螳 覃 . DSN Data Source Names 曙
import pyodbc conn = pyodbc.connect(driver='{SQL Server}', host='localhost,1433', database='pubs', user='id', password='pass') cursor = conn.cursor() cursor.execute(""" select type , count(*) cnt from dbo.titles group by type order by 2 desc """) rows = cursor.fetchall() for row in rows: print (row.type, row.cnt)
鏤
|
螳 谿語襷螻 企る. 覃 語企. 蠏殊蟇煙 朱 覈語 讌. 一誤 襴襦 碁襯 覿. . 覩語覃 蠍 企. |