Skip to content

Instantly share code, notes, and snippets.

@parzibyte
Created July 2, 2019 23:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save parzibyte/8481e0d0797a20d6840b3675c82ba7be to your computer and use it in GitHub Desktop.
Save parzibyte/8481e0d0797a20d6840b3675c82ba7be to your computer and use it in GitHub Desktop.
import pymysql
try:
conexion = pymysql.connect(host='localhost',
user='root',
password='',
db='peliculas')
try:
with conexion.cursor() as cursor:
consulta = "DELETE FROM peliculas WHERE anio < %s;"
anio = 2000
cursor.execute(consulta, (anio))
# No olvidemos hacer commit cuando hacemos un cambio a la BD
conexion.commit()
finally:
conexion.close()
except (pymysql.err.OperationalError, pymysql.err.InternalError) as e:
print("Ocurrió un error al conectar: ", e)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment