我希望在python中使用sql中的表。我想将整个表存储在一个名为“mat”的矩阵中,然后在python代码之后获得输出,这样我就可以用sql再次读取该表。我就是这样开始的:
import pyodbc
import pandas as pd
server = 'myserver'
database = 'mydatabase'
username = 'myuser'
password = 'mypassword'
cnxn = pyodbc.connect('DRIVER={ODBC Driver 13 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
******Python code*******
mat=pd.read_sql('select * from mytable order by time' , con = cnxn)
如何读取表以将其存储在mat中,然后如何将其发送回sql?
