python 中mysql数据库的读写

最新推荐文章于 2024-05-29 19:46:05 发布

weixin_30279315

最新推荐文章于 2024-05-29 19:46:05 发布

阅读量222

点赞数

文章标签：数据库 python

原文链接：http://www.cnblogs.com/wl2017/p/10638219.html

版权

1.读取数据库

 1 import pymysql
 2 id=[]
 3 name=[]
 4 explain=[]
 5 db=pymysql.Connection(host="localhost",port=3307,user="root", password="root",database="jiansuo",charset="utf8")
 6 cursor=db.cursor()
 7 sql="select * from yuan"
 8 try:
 9     cursor.execute(sql)
10     results=cursor.fetchall()
11     for row in results:
12         id.append(row[0])
13         name.append(row[1])
14         explain.append(row[2])
15 except:
16     print("出错了！")
17 db.close()

2.写入数据库

 1 import pymysql
 2 id=[]
 3 name=[]
 4 explain=[]
 5 db=pymysql.Connection(host="localhost",port=3307,user="root", password="root",database="jiansuo",charset="utf8")
 6 cursor=db.cursor()
 7 sql="select * from yuan"
 8 try:
 9     cursor.execute(sql)
10     results=cursor.fetchall()
11     for row in results:
12         id.append(row[0])
13         name.append(row[1])
14         explain.append(row[2])
15 except:
16     print("出错了！")
17 db.close()