python操作mysql

標籤：

python通過MySQLdb模組編輯mysql資料庫，python3使用pymysql模組

添加資料

 1 import pymysql 2  3 conn = pymysql.connect(host=‘127.0.0.1‘,user=‘root‘,passwd=‘xilehang99‘,db=‘liyaoguo‘) 4  5 cur = conn.cursor() 6  7 reCount = cur.execute(‘insert into students(name,sex,age,tel,nal) values(%s,%s,%s,%s,%s)‘,(‘jack‘,‘F‘,23,123456,‘chain‘)) 8  9 conn.commit()10 11 cur.close()12 conn.close()13 14 print (reCount)

查看資料

 1 import pymysql 2  3 conn = pymysql.connect(host=‘127.0.0.1‘,user=‘root‘,passwd=‘xilehang99‘,db=‘liyaoguo‘) 4  5 cur = conn.cursor() 6  7 reCount = cur.execute(‘select * from students‘)  #查詢表內容 8  9 conn.commit()10 11 cur.close()12 conn.close()13 14 print (reCount)15 print(cur.fetchone())  #擷取一條結果16 print(cur.fetchmany(2))  #擷取前兩條結果17 print(cur.fetchall())  #擷取所有結果

修改資料

 1 import pymysql 2  3 conn = pymysql.connect(host=‘127.0.0.1‘,user=‘root‘,passwd=‘xilehang99‘,db=‘liyaoguo‘) 4  5 cur = conn.cursor() 6  7 reCount = cur.execute(‘update students set Name = %s‘,(‘alin‘,))  #修改資料 8 reCount = cur.execute(‘delete from students‘)  #刪除資料 9 10 conn.commit()11 12 cur.close()13 conn.close()14 15 print (reCount)

 

python操作mysql