顾乔芝士网

import pymysql

# 链接数据库
db = pymysql.connect(host='localhost',
                     port=3306,
                     user='root',
                     password='root',
                     db='student_info',
                     charset='utf8'
                     )

# 创建游标
cursor = db.cursor()
# 如果表存在， 先删除
sqlCmd = "DROP TABLE IF EXISTS student_info"
cursor.execute(sqlCmd)
# 设定sql语句
sqlAdd = """
             CREATE TABLE student (sno char(5), 
                                sname char(10), 
                                ssex char(2),
                                sage int);
        """
cursor.execute(sqlAdd)
# 关闭
cursor.close()
db.close()