import pymysql
创建数据库
db = pymysql.connect(host=‘127.0.0.1’, user=‘root’, password=‘774110919’, port=3306)
cursor = db.cursor()
cursor.execute("CREATE DATABASE QQ_M
usic DEFAULT CHARACTER SET utf8mb4")
db.close()
import pymysql
创建表格, 设置主键
db = pymysql.connect(host=‘127.0.0.1’, user=‘root’, password=‘774110919’, port=3306, db=‘QQ_Music’)
cursor = db.cursor()
sql = ‘CREATE TABLE IF NOT EXISTS comments (nike VARCHAR(255) NOT NULL, comment VARCHAR(255) NOT NULL, praisenum INT NOT NULL, comment_id VARCHAR(255) NOT NULL, time VARCHAR(255) NOT NULL, PRIMARY KEY (comment))’
cursor.execute(sql)
db.close()
针对音乐中去年夏天的网页进行分析,查看了所有评论的尾页,发现时间缩水了,因为热评中有一条评论的时间7月12号&#