# c:\Users\user_nm\AppData\Local\Programs\Python\Python35-32\Scripts\pip install mysql-connector
import mysql.connector
db = mysql.connector.connect(
host="localhost",
user="root",
passwd="",
database="python_database"
)
db_cursor = db.cursor()
sql = "INSERT INTO workers (name, profession) VALUES (%s, %s)"
val = ("Fox", "Python Programmer")
db_cursor.execute(sql, val)
db.commit()
print("A total of:", db_cursor.rowcount, "record inserted")
'''
run:
A total of: 1 record inserted
'''