insert statements using in video tutorial

insert-sql.py

# Pull in .secrets
import os
import mysql.connector

mydb = mysql.connector.connect(
  host='nnsgluut5mye50or.cbetxkdyhwsb.us-east-1.rds.amazonaws.com',
  user=os.environ.get('user'),
  password=os.environ.get('password'),
  port=3306,
  database='jsfaxdu1coljgpvy'
)

# sql = "CREATE TABLE customers (name VARCHAR(255), address VARCHAR(255))"
mycursor = mydb.cursor()

# Begin insert Statements
sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"
val = ("John", "Highway 21")
mycursor.execute(sql, val)

mydb.commit()