Insertar datos a Workbench desde Python

CODIGO:

 
import pymysql.connections

db = pymysql.connect(host='localhost',user='root',password='kennethbd',db='escuela')

cursor = db.cursor()

sql = "INSERT INTO alumnos (idalumnos, Salon, Nombre) VALUES (%s, %s, %s)"
val = (17260571,"3A", "Kenneth")
cursor.execute(sql, val)

db.commit()

print(cursor.rowcount, "record inserted.")

Links para mas informacion de Python y Workbench:
http://copitosystem.com/es/python-mysql-database/
https://parzibyte.me/blog/2018/09/18/python-3-mysql-crud-ejemplos-conexion/ https://www.w3schools.com/python/python_mysql_insert.asp