python如何连接数据库

import pymysql
con=pymysql.connect(host='localhost',
                    user='root',
                    password='123456',
                    port=3306,
                    database='python')#连接的关键字设置
cursor = con.cursor()
sql = 'select * from sheet1 limit 5;'
cursor.execute(sql)
for i in cursor.fetchall():
    print(i)
#也可以用pandas
pd.read_sql_query(sql,con)
输出：

    order_id    order_date  order_time  status  user_id total_amount
0   3897894579  2010-03-11  0 days  PENDING_ORDER_CONFIRM   1038166 59.0
1   3897983041  2010-03-11  0 days  REMOVED 1041656 20.0
2   3898082203  2010-03-11  0 days  NO_PENDING_ACTION   1051321 199.0
3   3885060550  2010-03-11  0 days  NO_PENDING_ACTION   1052833 449.0
4   3885060551  2010-03-11  0 days  NO_PENDING_ACTION   1053309 3499.0