Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- from mysql.connector import Error
- from mysql.connector import errorcode
- try:
- connection = mysql.connector.connect(host='localhost',
- database='sakila',
- user='root',
- password='Brownie2')
- mySql_insert_query = """INSERT INTO actor (actor_id,first_name,last_name,last_update)
- VALUES
- ('202','Harry','Potter','2019-11-20 14:00:00') """
- cursor = connection.cursor()
- result = cursor.execute(mySql_insert_query)
- connection.commit()
- cursor.close()
- ERROR:
- File "<ipython-input-5-1dccea6b009e>", line 18
- ^
- SyntaxError: unexpected EOF while parsing
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement