Py之PyMySQL：Python库之PyMySQL的简介、安装、使用方法之详细攻略

 

 

 

目录

PyMySQL的简介

PyMySQL的安装

PyMySQL的使用方法

---

 

 

 

PyMySQL的简介

    PyMySQL包包含一个纯Python MySQL客户端库。PyySQL的目标是对MySQL LDAP进行替换，并对CPython、PyPy和IrPython进行工作。
PyMySQL
Welcome to PyMySQL’s documentation! 

 

 

 

PyMySQL的安装

pip install PyMySQL

 

 

 

PyMySQL的使用方法

python操作mysql数据库

import pymysql.cursors# Connect to the database
connection = pymysql.connect(host='localhost',user='user',password='passwd',db='db',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor)try:with connection.cursor() as cursor:# Create a new recordsql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"cursor.execute(sql, ('webmaster@python.org', 'very-secret'))# connection is not autocommit by default. So you must commit to save# your changes.connection.commit()with connection.cursor() as cursor:# Read a single recordsql = "SELECT `id`, `password` FROM `users` WHERE `email`=%s"cursor.execute(sql, ('webmaster@python.org',))result = cursor.fetchone()print(result)
finally:connection.close()