Create Table / Insert (I)

import sys

import mysql.connector as mc

try:

connection = mc.connect (host = "localhost",

user = "pytester",

passwd = "monty",

db = "company")

except mc.Error as e:

print("Error %d: %s" % (e.args[0], e.args[1]))

sys.exit(1)

cursor = connection.cursor()

cursor.execute ("DROP TABLE IF EXISTS employee")