mysql.connector.errors.InterfaceError: Failed executing the operation; Not all parameters were used in the SQL statement code example
Example: mysql.connector.errors.InterfaceError: Failed executing the operation; Not all parameters were used in the SQL statement
# just use %s
add_user = """INSERT INTO DB.tbluser
(username, department, startyear, currentpos, link)
VALUES (%s, %s, %s, %s, %s)"""