For SQL online video

connect.py

import os
import mysql.connector

mydb = mysql.connector.connect(
  host='',
  user='',
  password='',
  port=3306,
  database=''
)

sql = "SELECT * FROM customers;"
mycursor = mydb.cursor()
mycursor.execute(sql)
if 'INSERT' in sql:
    mydb.commit() # required to make table changes
    print("Last inserted ID:", mycursor.lastrowid)
if 'SELECT' in sql:
    myresult = mycursor.fetchall()
    for x in myresult:
        print(x)