Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- from mysql.connector import errorcode
- try:
- cnn = mysql.connector.connect(
- user='root',
- password='',
- host='localhost',
- database='vuelos')
- print("It Works!!")
- except mysql.connector.Error as e:
- if e.errno == errorcode.ER_ACCES_DENIED_ERROR:
- print("Something is wrong with username or Password")
- elif e.errno== errorcode.ER_ACCES_DENIED_ERROR:
- print("Database dont exist")
- else:
- print(e)
- cursor = cnn.cursor()
- cursor.execute("INSERT INTO `clientes` (`id`, `DNI`, `Nombre`) VALUES (NULL, '123456', 'peter')")
- cnn.commit()
- cursor.close()
- cnn.close()
Add Comment
Please, Sign In to add comment