pip install mysql-connector-python

import mysql.connector
import json
from datetime import datetime
 
 
# 創(chuàng)建數(shù)據(jù)庫連接
db = mysql.connector.connect(
    host="localhost",  # MySQL服務(wù)器地址
    user="root",           # 用戶名
    password="123456",  # 密碼
    database="test",  # 數(shù)據(jù)庫名稱
    port="3307"             # 端口
)
 
 
# 創(chuàng)建游標(biāo)對象，用于執(zhí)行SQL查詢
cursor = db.cursor()
 
 
# 讀取JSON文件并解析為Python字典
with open('./data/goods_2025-02-12.json', 'r', encoding='utf-8') as file:
    goods = json.load(file)
 
 
# 將字典轉(zhuǎn)換為JSON字符串
goods_json = json.dumps(goods, ensure_ascii=False)
 
 
# 日期
date = '2025-02-12'
 
 
# 執(zhí)行SQL
sql = "INSERT INTO goods (content, date) VALUES (%s, %s)"
val = (goods_json, date)
cursor.execute(sql, val)
 
 
# 提交事務(wù)
db.commit()
 
 
# 關(guān)閉游標(biāo)和數(shù)據(jù)庫連接
cursor.close()
db.close()

import mysql.connector
import json
from datetime import datetime
 
 
# 創(chuàng)建數(shù)據(jù)庫連接
db = mysql.connector.connect(
    host="localhost",  # MySQL服務(wù)器地址
    user="root",           # 用戶名
    password="123456",  # 密碼
    database="test",  # 數(shù)據(jù)庫名稱
    port="3307"             # 端口
)
 
 
# 創(chuàng)建游標(biāo)對象，用于執(zhí)行SQL查詢
cursor = db.cursor()
 
 
sql = "SELECT * FROM goods WHERE date = %s"
val = ('2025-02-12',)
cursor.execute(sql, val)
 
 
# 獲取查詢結(jié)果
result = cursor.fetchall()
 
 
# 遍歷結(jié)果并打印
for row in result:
    print(row)
 
 
# 獲取商品信息(json格式)
goods = json.loads(row[1])
    
# 提交事務(wù)
db.commit()
 
 
# 關(guān)閉游標(biāo)和數(shù)據(jù)庫連接
cursor.close()
db.close()