import pandas as pd
import pymysql # Linux Windows 都可以用, 可以导入,不能导出, 导出还得要 mysqldb
con = pymysql.connect(host='192.168.0.10', user='lwn', passwd='123456', db='PATENT', port = 3306) # 连接
cur = con.cursor()
def read_table(cur, sql_order): # sql_order is a string
try:
cur.execute(sql_order) # 多少条记录
data = cur.fetchall( )
frame = pd.DataFrame(list(data))
except: #, e:
frame = pd.DataFrame()
# print e
# continue
return frame
con.commit()
cur.close()
con.close()
后来发现省事的法子,原来的法子可以帮助理解实现方法
engine = create_engine('mysql://root:123456@192.168.0.10/SMLRT_822')
table=sql.read_sql_table(I[i], engine)
table=sql.read_sql_table(I[i], engine)
参python文档:http://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_sql_table.html