如何将web抓取的数据从Python/Beautiful Soup放入MySQL数据库

import requests
from bs4 import BeautifulSoup
import mysql.connector

# 发送HTTP请求，获取网页内容
response = requests.get('https://example.com')
html_content = response.text

# 解析网页内容，提取所需数据
soup = BeautifulSoup(html_content, 'html.parser')
data = soup.find('div', class_='data').text

# 连接到MySQL数据库
cnx = mysql.connector.connect(
    host='localhost',
    user='username',
    password='password',
    database='database_name'
)

# 创建数据表（如果不存在）
cursor = cnx.cursor()
create_table_query = '''
    CREATE TABLE IF NOT EXISTS web_data (
        id INT AUTO_INCREMENT PRIMARY KEY,
        data VARCHAR(255)
    )
'''
cursor.execute(create_table_query)

# 插入数据
insert_data_query = '''
    INSERT INTO web_data (data) VALUES (%s)
'''
cursor.execute(insert_data_query, (data,))

# 提交更改并关闭连接
cnx.commit()
cursor.close()
cnx.close()