PyMySQL

　　

　　　　PyMySQL是基于python连接操作mysql库的第三方库

  • 　介绍：代码托管地址：https://github.com/PyMySQL/PyMySQL
  •     在线文档：https://pymysql.readthedocs.io/en/latest/index.html

　

安装

　　 python3 -m pip install PyMySQL

 

环境要求

  • Python – one of the following:
  • MySQL Server – one of the following:

示例

可以使用分步式的写法，创建连接，创建游标，执行语句，关闭游标，关闭连接的方式，使用mysql数据库。

但是不建议这样做，建议使用关键字with使用PyMySQL操作mysql数据库：

 1 import pymysql.cursors
 2 
 3 # Connect to the database
 4 connection = pymysql.connect(host='localhost',
 5                              user='user',
 6                              password='passwd',
 7                              database='db',
 8                              charset='utf8mb4',
 9                              cursorclass=pymysql.cursors.DictCursor)
10 
11 with connection:
12     with connection.cursor() as cursor:
13         # Create a new record
14         sql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"
15         cursor.execute(sql, ('webmaster@python.org', 'very-secret'))
16 
17     # connection is not autocommit by default. So you must commit to save
18     # your changes.
19     connection.commit()
20 
21     with connection.cursor() as cursor:
22         # Read a single record
23         sql = "SELECT `id`, `password` FROM `users` WHERE `email`=%s"
24         cursor.execute(sql, ('webmaster@python.org',))
25         result = cursor.fetchone()
26         print(result)

 

 

 

实战：

待补充：......

 

 

 

 参考：

https://github.com/chendemo12/knowledgegraph/wiki/pymysql%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3

https://pymysql.readthedocs.io/en/latest/index.html