Create MySQL Database & Table

import mysql.connector

conn = mysql.connector.connect(

  host="localhost", user="root", passwd="bont", database="binoy")

cur = conn.cursor()

################# CREATE DATABASE ###################

cur.execute("CREATE DATABASE binoy")

cur.execute("SHOW DATABASES")

for db in cur:

  print(db)

################# CREATE TABLE ###################

print("")

cur.execute("USE binoy")

cur.execute("SHOW TABLES")

for table in cur:

  print("binoy ->", table)

cur.execute("CREATE TABLE IF NOT EXISTS customers(\

            cid INTEGER, fname VARCHAR(15),\

            lname VARCHAR(15), city VARCHAR(15))")

################# ALTER TABLE ###################

cur.execute("ALTER TABLE customers ADD(pin INTEGER)")

conn.commit()

conn.close()