import pymysql
# 打开数据库
db = pymysql.connect("172.16.27.130", "root", "Hou.fei12345", "hou")
# 使用cursor()方法创建光标
cursor = db.cursor()
# 如果表已经存在,使用execute() 删除表
cursor.execute("drop table if EXISTS EMPLOYEE")
# 创建数据表SQL语句
sql = """CREATE TABLE EMPLOYEE (
FIRST_NAME CHAR(20) NOT NULL,
LAST_NAME CHAR(20),
AGE INT,
SEX CHAR(1),
INCOME FLOAT )"""
try:
cursor.execute(sql)
db.commit()
except:
# 出错时回滚(Rollback in case there is any error)
db.rollback()
db.close()