Python操作Mysql数据库

一、下载导入第三方库：

        1.pip install pymysql

        2.直接在pycharm中导入

二、阅读源码，得知连接需要的参数，以及类型：

 

得知最少需要，主机名、用户名、密码、数据库以及端口号，且端口号为整形，其余为str

三、Demo：

tips：注意一下事物的提交，以及sql注入问题，有点格式化输出的意思

from pymysql import *
try:
    con = connect('localhost', 'root', 'usbw', 'skh', 3306)
except MySQLError as msg:
    print(msg)
cur = con.cursor()
#查询
count = cur.execute("select * from qwe")
print(count)
result = cur.fetchall()
for i in result:
    print(i)
#增加
count1 = cur.execute("insert into qwe values(%d, %s, %s, %s, %d)" %(101, "'Python'", "'Mysql'", "'Sex'", 1))
con.commit()
print(count1)
#删除
count2 = cur.execute("delete from qwe where id = %d" %(4))
con.commit()
print(count2)
count2 = cur.execute("update qwe set password = %s where id = %d" %("'PyMysql'", 101))
con.commit()
print(count2)
cur.close()
con.close()