mysql数据库里怎么存图片

CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    image BLOB
);

import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(host='localhost',
                                         database='your_database',
                                         user='your_username',
                                         password='your_password')

    cursor = connection.cursor()

    with open('path_to_your_image.jpg', 'rb') as file:
        binary_data = file.read()

    insert_query = "INSERT INTO images (name, image) VALUES (%s, %s)"
    cursor.execute(insert_query, ('image_name', binary_data))
    connection.commit()

except Error as e:
    print("Error while connecting to MySQL", e)

finally:
    if connection.is_connected():
        cursor.close()
        connection.close()

try:
    connection = mysql.connector.connect(host='localhost',
                                         database='your_database',
                                         user='your_username',
                                         password='your_password')

    cursor = connection.cursor()

    select_query = "SELECT name, image FROM images WHERE id = %s"
    cursor.execute(select_query, (image_id,))
    record = cursor.fetchone()

    if record:
        with open(f"retrieved_{record[0]}", 'wb') as file:
            file.write(record[1])

except Error as e:
    print("Error while connecting to MySQL", e)

finally:
    if connection.is_connected():
        cursor.close()
        connection.close()

CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    path VARCHAR(255)
);

import os
import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(host='localhost',
                                         database='your_database',
                                         user='your_username',
                                         password='your_password')

    cursor = connection.cursor()

    image_path = 'path_to_save_image/image_name.jpg'
    with open('path_to_your_image.jpg', 'rb') as file:
        with open(image_path, 'wb') as new_file:
            new_file.write(file.read())

    insert_query = "INSERT INTO images (name, path) VALUES (%s, %s)"
    cursor.execute(insert_query, ('image_name', image_path))
    connection.commit()

except Error as e:
    print("Error while connecting to MySQL", e)

finally:
    if connection.is_connected():
        cursor.close()
        connection.close()

try:
    connection = mysql.connector.connect(host='localhost',
                                         database='your_database',
                                         user='your_username',
                                         password='your_password')

    cursor = connection.cursor()

    select_query = "SELECT path FROM images WHERE id = %s"
    cursor.execute(select_query, (image_id,))
    record = cursor.fetchone()

    if record:
        image_path = record[0]
        # 处理图片路径，例如将其提供给前端或进行其他操作

except Error as e:
    print("Error while connecting to MySQL", e)

finally:
    if connection.is_connected():
        cursor.close()
        connection.close()