Guest User

Untitled

a guest
Feb 7th, 2018
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. import mysql.connector
  2. from mysql.connector import errorcode
  3.  
  4. try:
  5. cnn = mysql.connector.connect(
  6. user='root',
  7. password='',
  8. host='localhost',
  9. database='vuelos')
  10. print("It Works!!")
  11. except mysql.connector.Error as e:
  12. if e.errno == errorcode.ER_ACCES_DENIED_ERROR:
  13. print("Something is wrong with username or Password")
  14. elif e.errno== errorcode.ER_ACCES_DENIED_ERROR:
  15. print("Database dont exist")
  16. else:
  17. print(e)
  18.  
  19. cursor = cnn.cursor()
  20.  
  21. cursor.execute("INSERT INTO `clientes` (`id`, `DNI`, `Nombre`) VALUES (NULL, '123456', 'peter')")
  22. cnn.commit()
  23. cursor.close()
  24. cnn.close()
Add Comment
Please, Sign In to add comment