1、导入库

import pymysql

2、连接数据库

db = pymysql.connect(host='127.0.0.1',
                    user='root', 
                    passwd="root", 
                    db='python_data')

3、创建一个游标对象 cursor

cursor = db.cursor()

4、编写SQL语句

sql = "SELECT * FROM `order`"

5、执行SQL语句

cursor.execute(sql)  ---> 65535

6、通过fetchall获得数据，数据以元组形式保存

data = cursor.fetchall()

7、打印前2条数据

for i in data[:2]:
    print(i)

--->
('3897894579', '2010-03-11', '00:00:00', 'PENDING_ORDER_CONFIRM', '1038166', '59.0000000')
('3897983041', '2010-03-11', '00:00:00', 'REMOVED', '1041656', '19.9000000')

8、关闭游标

cursor.close()

9、关闭数据库连接

db.close()