python图片存入mysql数据库中

import mysql.connector
from mysql.connector import Error
from mysql.connector import errorcode
from PIL import Image
import io

try:
    connection = mysql.connector.connect(host='your_host',
                                         database='your_database',
                                         user='your_username',
                                         password='your_password')
    if connection.is_connected():
        print('Connected to MySQL database')
except Error as e:
    print(f"Error while connecting to MySQL: {e}")

create_table_query = '''CREATE TABLE IF NOT EXISTS images
                            (id INT AUTO_INCREMENT PRIMARY KEY,
                             name VARCHAR(100) NOT NULL,
                             data MEDIUMBLOB NOT NULL)'''
try:
    cursor = connection.cursor()
    cursor.execute(create_table_query)
    connection.commit()
    print('Table created successfully')
except Error as e:
    print(f"The error '{e}' occurred")

file_path = 'path_to_image_file.jpg'  # 替换为实际图片文件的路径

try:
    with open(file_path, 'rb') as file:
        image_data = file.read()
    
    insert_query = '''INSERT INTO images (name, data) VALUES (%s, %s)'''
    insert_values = ('image_name', image_data)  # 替换为实际的图片名称
    cursor = connection.cursor()
    cursor.execute(insert_query, insert_values)
    connection.commit()
    print('Image saved to database')
except Error as e:
    print(f"The error '{e}' occurred")