数据来源
url='https://user.guancha.cn/app/pneumonia'
数据库
user='root', password='12345678',
db='COVID19db
代码
import requests
from lxml import etree
import time
# import csv
import pymysql
def data_writer(country1,diagnosis1,died1,cure1,date1):
conn = pymysql.connect(host='localhost', port=3306, user='root', password='12345678', db='COVID19db', charset='utf8',
connect_timeout=1000)
cursor = conn.cursor()
sql = """create table if not exists 14COVID2021 (id int(10) primary key auto_increment,国家 varchar(100),确诊 varchar(50),死亡 varchar(50),治愈 varchar(50),日期 varchar(50))"""
cursor.execute(sql) # 执行创建表的sql语句
cursor.execute("show tables") #