import pymysqlcoon = pymysql.connect(      host = '127.0.0.1',      user = 'root',      passwd = '123456',      port = 3306, #port必须写int类型      db = 'mydb',      charset = 'utf8' #charset必须写utf8，不能写utf-8    )cur = coon.cursor()  #建立游标cur.execute('delete from student where id=5')cur.execute('insert into student (id, name) values (5,\'张三\')')coon.commit()cur.execute("select * from student")res = cur.fetchall()    #获取结果print(res)cur.close()     #关闭游标coon.close()    #关闭连接

注意，请先PIP 下 pymysql

 

Enjoy :)