python——mysql与python交互

sudo apt-get  install python-mysqldb

image.png

Connection 对象

Cursor对象

增加

安装pymysql的方法
https://blog.csdn.net/medivhq/article/details/73831386

import pymysql
try:
    conn = pymysql.connect(host='localhost', user='root', passwd='xjx', db='epoque', port=3306, charset='utf8')
    cur = conn.cursor()
    sql = 'insert into students(name) values("LiMing")'
    cur.execute(sql)
    conn.commit()
    cur.close()
    conn.close()
except Exception as e:
    print(e)

sql语句参数化

import pymysql
try:
    conn = pymysql.connect(host='localhost', user='root', passwd='xjx', db='epoque', port=3306, charset='utf8')
    cur = conn.cursor()
    # sql = 'delete from students where id>3'
    name = input("请输入用户名：")
    sql = 'insert into students(name) values(%s)'
    cur.execute(sql, [name])
    conn.commit()
    cur.close()
    conn.close()
    print('ok')
except Exception as e:
    print(e)