Python操作MySql
二 Python创建数据库与表
![image-20220302152031428](https://i-blog.csdnimg.cn/blog_migrate/89903425a6ed9dede91d147a81c12507.png)
2.1 创建数据库
import pymysql
con = pymysql.connect(host='localhost',port=3306,user='root',passwd='root',charset='utf8')
coursor = con.cursor()
sql = '''
CREATE DATABASE sxt
DEFAULT CHARACTER SET = 'utf8mb4';
'''
coursor.execute(sql)
coursor.close()
con.close()
2.2 创建数据表
import pymysql
con = pymysql.connect(host='localhost',port=3306,user='root',passwd='root',charset='utf8',db='sxt')
coursor = con.cursor()
sql = '''
CREATE TABLE t_user(
id int NOT NULL PRIMARY KEY AUTO_INCREMENT COMMENT 'Primary Key',
uname VARCHAR(32) not null,
age int(11) not null,
sex VARCHAR(5)
) DEFAULT CHARSET UTF8;
'''
coursor.execute(sql)
coursor.close()
con.close()