创建Mysql数据库数据表

Mankiw

import pymysql
db = pymysql.connect(
    host = "localhost",
    user = "root",
    password = "******",
    database = "studyPython",
    charset = "utf8mb4"
)
cursor = db.cursor()
cursor.execute("DROP TABLE IF EXISTS books")
sql = """
CREATE TABLE books(
    id int(8) NOT NULL AUTO_INCREMENT,
    name varchar(50) NOT NULL,
    category varchar(50) NOT NULL,
    price decimal(10,2) DEFAULT NULL,
    publish_time date DEFAULT NULL,
    PRIMARY KEY (id)
)ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;
"""
cursor.execute(sql)
db.close