pymysql的修改、删除、增加

增加

import pymysql
try:
    connc = pymysql.connect(
        host='127.0.0.1',
        user='root',
        password='020804',
        database='person',
        port=3305,
        charset='utf8'
    )
    cur = connc.cursor()
    sql = 'insert into info values(%s,%s,%s,%s)'
    add_data = [0,'刘德华',56,'男']
    cur.execute(sql,add_data)
    connc.commit()
    cur.close()
    connc.close()
    print('添加成功')
except Exception as e:
    print(e)

修改

import pymysql
try:
    connc = pymysql.connect(
        host='127.0.0.1',
        user='root',
        password='020804',
        database='person',
        port=3305,
        charset='utf8'
    )
    cur = connc.cursor()
    sql = 'update info set name=%s where name="1"'
    update_data = ['11']
    cur.execute(sql,update_data)
    connc.commit()
    cur.close()
    connc.close()
    print('修改成功')
except Exception as e:
    print(e)

删除

import pymysql
try:
    connc = pymysql.connect(
        host='127.0.0.1',
        user='root',
        password='020804',
        database='person',
        port=3305,
        charset='utf8'
    )
    cur = connc.cursor()
    sql = 'delete from info where name=%s'
    del_data=['2']
    cur.execute(sql,del_data)
    connc.commit()


except Exception as e:
    print(e)
    #数据回滚
    connc.rollback()
finally:
    cur.close()
    connc.close()

print('删除成功')