怎么把图片存进mysql数据库

import mysql.connector

# 建立与MySQL数据库的连接
conn = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

# 读取图片文件为二进制数据
with open("image.jpg", "rb") as f:
    image_data = f.read()

# 插入图片数据到数据库
cursor = conn.cursor()
insert_query = "INSERT INTO images (name, path, data) VALUES (%s, %s, %s)"
values = ("image.jpg", "/images/image.jpg", image_data)
cursor.execute(insert_query, values)
conn.commit()
print("Image inserted successfully.")

# 查询图片数据
select_query = "SELECT * FROM images WHERE name = %s"
values = ("image.jpg",)
cursor.execute(select_query, values)
image = cursor.fetchone()
if image:
    image_data = image[3]
    # 将二进制数据写入新文件
    with open("image_new.jpg", "wb") as f:
        f.write(image_data)
    print("Image retrieved successfully.")

# 关闭数据库连接
cursor.close()
conn.close()