如何将这个json(post)插入到mariadb中？

CREATE TABLE your_table_name (
  id INT AUTO_INCREMENT PRIMARY KEY,
  field1 VARCHAR(255),
  field2 INT,
  field3 DECIMAL(10,2),
  ...
);

import json
import pymysql

# 解析JSON数据
json_data = '{"field1": "value1", "field2": 123, "field3": 45.67}'

data = json.loads(json_data)

# 建立与MariaDB的连接
conn = pymysql.connect(host='your_host', user='your_user', password='your_password', db='your_database')

# 创建一个游标对象
cursor = conn.cursor()

# 构建插入语句
sql = "INSERT INTO your_table_name (field1, field2, field3) VALUES (%s, %s, %s)"
values = (data['field1'], data['field2'], data['field3'])

# 执行插入语句
cursor.execute(sql, values)

# 提交事务
conn.commit()

# 关闭游标和连接
cursor.close()
conn.close()