手把手带你入门Python爬虫（三、PyMySQL）

1、安装

pip install PyMySQL

2、新建Mysql数据表

使用Navcat for Mysql 创建数据库py_spider，创建数据表users，新建字段：

3、使用pymysql

import pymysql.cursors

# 连接数据库
connection = pymysql.connect(host='localhost',
                             port=3307,
                             user='root',
                             password='root',
                             db='py_spider',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

try:
	# 插入一条数据
    with connection.cursor() as cursor:
        sql = "insert into `users` (`email`,`password`) values (%s, %s)"
        cursor.execute(sql, ('zhangsan@qq.com','123456'))
    connection.commit()
	
	# 查询数据
    with connection.cursor() as cursor:
        sql = "select * from `users` where `email`=%s"
        cursor.execute(sql, ('zhangsan@qq.com',))
        result = cursor.fetchone()
        print(result)
finally:
    connection.close()