#!/usr/local/bin/python3.7

import mysql.connector
from mysql.connector import errorcode

con = mysql.connector.connect(
    user='root',
    password='root',
    host='localhost',
    port= '8889',
    database= 'Nov29',
)
print("It Works")


cursor = con.cursor()

addCon = ("INSERT INTO PhoneBook (ContactNo, ContactName,
ContactAddress) VALUES (%s,%s,%s)")
conNo = "4161313131"
conName = "Rin Okumura"
conAddress = "Cross Academy"
insertSql = (conNo,conName,conAddress)

cursor.execute(addCon,insertSql)

con.commit()
cursor.close()
con.close()

It Works
File "/Users/atheyaramotar/PycharmProjects/Week12/connect.py", line 24, in <module>
cursor.execute(addCon,insertSql)
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/mysql/connector/cursor.py", line 569, in execute self._handle_result(self._connection.cmd_query(stmt))
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/mysql/connector/connection.py", line 550, in cmd_query
result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/mysql/connector/connection.py", line 439, in _handle_result
raise errors.get_exception(packet)
mysql.connector.errors.DataError: 1264 (22003): Out of range value for column 'ContactNo' at row 1