Python-pymysql建表

import pymysql
zwy = pymysql.connect(host='localhost', user='root', password='123456789', db='world')
cursor = zwy.cursor()
create_sql = '''create table student (
sid char(10), 
sname varchar(20), 
ssex varchar(4)
)DEFAULT CHARSET=utf8;'''
# 执行
cursor.execute(create_sql)
# 关闭
zwy.close()