connection creation

Question

我正试图执行以下文字,但我没有获得预期结果,也没有错误信息。

import pyodbc 
cnxn = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
                        "Server=mySRVERNAME;"
                        "Database=MYDB;"
                        "uid=sa;pwd=MYPWD;"
                        "Trusted_Connection=yes;")


cursor = cnxn.cursor()
cursor.execute( select DISTINCT firstname,lastname,coalesce(middlename,   ) as middlename from Person.Person )

for row in cursor:
    print( row = %r  % (row,))

我如何能够从AQ服务器数据库获得数据?

Answer 1

你们必须与治疗师一道使用手法。例

for row in cursor.fetchall():
    print( row = %r  % (row,))

http://www.un.org。

独角兽部队在名单上的所有剩余行人都返回。

    If there are no rows, an empty list is returned. 
    If there are a lot of rows, *this will use a lot of memory.*

校对网关由数据库的驱动器以紧凑格式储存,通常从数据库服务器中分批发送。

<><>>> 只阅读你需要一度的浏览,就可以节省许多记忆<>>>>。

If we are going to process the rows one at a time, we can use the cursor itself as an interator Moreover we can simplify it since cursor.execute() always returns a cursor :

for row in cursor.execute("select bla, anotherbla from blabla"): 
    print row.bla, row.anotherbla

https://code.google.com/archive/p/pyodbc/wikis/GettingStarted.wiki” rel=“nofollow noreferer”>Documentation

Answer 2

I found this information useful to retrieve data from SQL database to python as a data frame.

import pandas as pd
import pymssql

con = pymssql.connect(server= use-et-aiml-cloudforte-aiops- db.database.windows.net ,user= login_username ,password= login_password ,database= database_name )
cursor = con.cursor()

query = "SELECT * FROM <TABLE_NAME>"
cursor.execute(query)
df = pd.read_sql(query, con)
con.close()

df

Answer 3

1. 进口我sql. 连接器作为立方米

connection creation

conn = mc.connect(host= localhost , user= root , passwd= password ) print(conn)

注

cur = conn.cursor() print(cur)

曲线(显示数据库)

for i in cur: print(i)

query = "Select * from employee_performance.employ_mod_recent" emp_data = pd.read_sql(query, conn) emp_data

connection creation

友情链接