一、安装
sudo apt-get install pymysql
sudo pip3 install pymysql
Connection对象
conn=connect(参数列表)
cursor1=conn.cursor()
二、python 与mysql 连接代码
from pymysql import *
try:
conn=Connection(host="localhost",port=3306,user="root",passwd="mysql",db=‘python3‘,charset="utf8")
cursor1=conn.cursor()
sql="insert into students(name) values(‘郭小二‘)"
#sql="update students set name= ‘王小二‘ where id = 9"
#sql="delete from students shere id=9"
cursor1.execute(sql)
conn.commit()
cursor1.close()
conn.close()
except Exception :
print("错误")
查询：
import MySQLdb
try:
conn=MySQLdb.connect(host=‘localhost‘,port=3306,db=‘test1‘,user=‘root‘,passwd=‘mysql‘,charset=‘utf8‘)
cur=conn.cursor()
cur.execute(‘select * from students‘)
result=cur.fetchall()
print result
cur.close()
conn.close()
except Exception,e:
print e.message
三、sql语句参数化
防止sql注入
from pymysql import *
try:
conn=Connection(host="localhost",port=3306,user="root",passwd="mysql",db=‘python3‘,charset="utf8")
cursor1=conn.cursor()
sname=raw_input("请输入学生姓名：")
params=[sname]
cursor1.execute("insert into students(sname) values(%s)",params)
conn.commit()
cursor1.close()
conn.close()
except Exception :
print("错误")
原文：https://www.cnblogs.com/ql0302/p/10621196.html