_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
FrontPage › Pyodbc
|
|
[edit]
2 pyodbc: 蠏谿 覯 #Windows OS ODBC誤 讌 . 蠏碁 蟯 り 螳覃 蟆.
import pyodbc conn = pyodbc.connect(driver='{SQL Server}', host='localhost,1433', database='pubs', user='id', password='pass') #ODBC 誤 朱 れ螻 螳 #conn = pyodbc.connect('DSN=dbserver01') 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)
鏤
|
譬り 讌襷 る 譬給. 蠏碁Μ螻 襦 伎殊 り給. 磯Μれ 螳 碁 讌 覿れ讌 給. (襴) |