pymysql

import pymysql
database = {
    'host':'maria',
    'database':'pythonrepo',
    'user':'root',
    'password':'666666',
    'charset':'utf8'
}
db = pymysql.connect(**database)
cursor = db.cursor();
cursor.execute("insert into test(name) values(%s)",("李四"))
cursor.execute("delete from test where name ='李四'")
cursor.execute("update test set name='张三' where id=2")
db.commit()
cursor.execute("select * from test")
result = cursor.fetchall()
for row in result:
    print(row)