大数据实践

import pymysql

connection = pymysql.connect(host='traindba.cookdata.cn',port=3360,user='raa_user',password='bigdata123',db='risk_assessment_analysis',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor)

try:
    with connection.cursor() as cursor:
        sql = "select * from all_data"
        cursor.execute(sql)
        all_data = cursor.fetchall()
finally:
    connection.close()

# 查看数据前两个元素
print(all_data[:2])