python 数据库 — pymysql库

pip install pymysql#安装

db = pymysql.connect("主机", "名称", "密码","库")
cursor = db.cursor()# 使用 cursor() 方法创建一个游标对象 cursor
cursor.execute(sql)#运行，sql是SQL语句
db.commit()# 提交到数据库执行 
cursor.fetchone()#获取单条数据.
cursor.fetchall()#返回全部的结果行.

例子：

import pymysql#导入
db = pymysql.connect("localhost", "gu", "123456","gu")
cursor = db.cursor()
csql =  "SELECT * FROM `tan` WHERE `title` LIKE '春'"
cursor.execute(csql)
results = cursor.fetchall()
print(results)
db.close()