这篇文章主要为大家详细介绍了python3.6简单操作mysql数据库，具有一定的参考价值，感兴趣的小伙伴们可以参考一下
本文为大家分享了python3.6操作mysql数据库的具体实例，供大家参考，具体内容如下
安装pymysql
参考https://github.com/pymysql/pymysql/
pip install pymsql
实例一
import pymysql # 创建连接 # 参数依次对应服务器地址，用户名，密码，数据库 conn = pymysql.connect(host='127.0.0.1', user='root', passwd='123456', db='demo') # 创建游标 cursor = conn.cursor(cursor=pymysql.cursors.dictcursor) # 执行语句返回影响的行数 effect_row = cursor.execute("select * from course") print(effect_row) # 获取所有数据 result = cursor.fetchall() result = cursor.fetchone() # 获取下一个数据 result = cursor.fetchone() # 获取下一个数据（在上一个的基础之上） # cursor.scroll(-1, mode='relative') # 相对位置移动 # cursor.scroll(0,mode='absolute') # 绝对位置移动 # 提交，不然无法保存新建或者修改的数据 conn.commit() # 关闭游标 cursor.close() # 关闭连接 conn.close()
实例二
import pymysql # 建立连接 conn = pymysql.connect(host='127.0.0.1', user='root', passwd='123456', db='demo') # 创建游标 cursor = conn.cursor(cursor=pymysql.cursors.dictcursor) # 插入一条数据 %s是占位符 占位符之间用逗号隔开 effect_row = cursor.execute("insert into course(cou_name,time) values(%s,%s)", ("engilsh", 100)) print(effect_row) conn.commit() cursor.close() conn.close()
实例三
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 record sql = "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 record sql = "select `id`, `password` from `users` where `email`=%s" cursor.execute(sql, ('webmaster@python.org',)) result = cursor.fetchone() print(result) finally: connection.close()
以上就是介绍python3.6简单操作mysql数据库的方法的详细内容。