python链接MySQL数据库

打开python编辑器pycharm,输入以下代码，如果链接成功，则会在EDUC数据库中完成sql1语句，可以在MySQL EDUC数据库中查看class表是否创建。

import pymysql as pymysql
conn = pymysql.connect(host='localhost'
, user='root'
, passwd=*******
, port=3306
, db='EDUC'
, charset='utf8'
)
cur = conn.cursor()
sql1 = "CREATE TABLE class (ClsNO char(6) PRIMARY KEY,ClsName varchar(16),Director varchar(10),Specialty varchar(30),stotal int,monitor varchar(50))"
cur.execute(sql1)
cur.close()
conn.close()