mysql数据库图片如何存储

CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    image_data LONGBLOB
);

import mysql.connector

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

# 读取图片文件
with open('image.jpg', 'rb') as file:
    image_data = file.read()

# 插入图片数据
cursor = cnx.cursor()
insert_query = "INSERT INTO images (image_data) VALUES (%s)"
cursor.execute(insert_query, (image_data,))
cnx.commit()

# 关闭连接
cursor.close()
cnx.close()

import mysql.connector

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

# 查询图片数据
cursor = cnx.cursor()
select_query = "SELECT image_data FROM images WHERE id = %s"
cursor.execute(select_query, (1,))
image_data = cursor.fetchone()[0]

# 将图片数据写入文件
with open('image.jpg', 'wb') as file:
    file.write(image_data)

# 关闭连接
cursor.close()
cnx.close()