import pymysql

db = pymysql.connect(host='localhost', user='root', password='root', port=3306, db='maoyan')
cursor = db.cursor()
sql = 'CREATE TABLE IF NOT EXISTS films (name VARCHAR(32) NOT NULL, type VARCHAR(255) NOT NULL, country VARCHAR(255) NOT NULL, length VARCHAR(255) NOT NULL, released VARCHAR(255) NOT NULL, score VARCHAR(255) NOT NULL, people INT NOT NULL, box_office BIGINT NOT NULL, PRIMARY KEY (name))'
cursor.execute(sql)
db.close()

0b687f961a2c12361cb288a41950333b7b85abaf
<mask token>

<mask token>
cursor.execute(sql)
db.close()

<mask token>
db = pymysql.connect(host='localhost', user='root', password='root', port=
    3306, db='maoyan')
cursor = db.cursor()
sql = (
    'CREATE TABLE IF NOT EXISTS films (name VARCHAR(32) NOT NULL, type VARCHAR(255) NOT NULL, country VARCHAR(255) NOT NULL, length VARCHAR(255) NOT NULL, released VARCHAR(255) NOT NULL, score VARCHAR(255) NOT NULL, people INT NOT NULL, box_office BIGINT NOT NULL, PRIMARY KEY (name))'
    )
cursor.execute(sql)
db.close()

import pymysql
db = pymysql.connect(host='localhost', user='root', password='root', port=
    3306, db='maoyan')
cursor = db.cursor()
sql = (
    'CREATE TABLE IF NOT EXISTS films (name VARCHAR(32) NOT NULL, type VARCHAR(255) NOT NULL, country VARCHAR(255) NOT NULL, length VARCHAR(255) NOT NULL, released VARCHAR(255) NOT NULL, score VARCHAR(255) NOT NULL, people INT NOT NULL, box_office BIGINT NOT NULL, PRIMARY KEY (name))'
    )
cursor.execute(sql)
db.close()

import pymysql

db = pymysql.connect(host='localhost', user='root', password='root', port=3306, db='maoyan')
cursor = db.cursor()
sql = 'CREATE TABLE IF NOT EXISTS films (name VARCHAR(32) NOT NULL, type VARCHAR(255) NOT NULL, country VARCHAR(255) NOT NULL, length VARCHAR(255) NOT NULL, released VARCHAR(255) NOT NULL, score VARCHAR(255) NOT NULL, people INT NOT NULL, box_office BIGINT NOT NULL, PRIMARY KEY (name))'
cursor.execute(sql)
db.close()
