python 中mysql数据库的读写

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()

 

posted @ 2019-04-01 19:03  我是一个粉刷匠^~^  阅读(981)  评论(0)  编辑  收藏  举报