import pandas as pd
import pymssql
conn = pymssql.connect("127.0.0.1",'user','123456','mydatabase')
sqlstr = "select * from Table_V_injector where Time_finish > '2019-05-10'"
df = pd.read_sql_query(con=conn,sql=sqlstr)
df取得后直接为dataframe数据格式
import pandas as pd
import pymssql
conn = pymssql.connect("127.0.0.1",'user','123456','mydatabase')
sqlstr = "select * from Table_V_injector where Time_finish > '2019-05-10'"
df = pd.read_sql_query(con=conn,sql=sqlstr)
df取得后直接为dataframe数据格式