安装过程 ：http://blog.topspeedsnail.com/archives/6018
注意
报错的话要先装一个东西
http://cdn.mysql.com/Downloads/Connector-Python/mysql-connector-python-2.0.4.zip#md5=3df394d89300db95163f17c843ef49df
然后 cd到装的这个目录
然后输入$ python setup.py install
import mysql.connector
import pandas as pd
conn = mysql.connector.connect(
user='aaa',
password='bbb',
host='11.11.11.11',
database='cc)
cur=conn.cursor()
query=("select time,match_id from match_h_data_real_team_id limit 10")
cur.execute(query)
data=cur.fetchall()
#for (time,match_id) in cur:
# print ("{},{}" .format(time,match_id ))
cur.close()
conn.close()
match_id
#print data
df=pd.DataFrame(data,columns=['time','match_id'])
df.head()