mysql将图片传入数据库中

-- 确保路径正确
INSERT INTO images (path) VALUES ('/correct/path/to/image.jpg');

-- 检查文件权限
chmod 755 /correct/path/to/image.jpg;

import mysql.connector

db = mysql.connector.connect(
    host="localhost",
    user="user",
    password="password",
    database="mydatabase"
)

cursor = db.cursor()

# 假设图片路径为 '/path/to/image.jpg'
sql = "INSERT INTO images (path) VALUES (%s)"
val = ("/path/to/image.jpg",)
cursor.execute(sql, val)

db.commit()
cursor.close()
db.close()

import mysql.connector
from mysql.connector import Error

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

    if connection.is_connected():
        cursor = connection.cursor()
        with open('/path/to/image.jpg', 'rb') as file:
            binary_data = file.read()
            insert_query = "INSERT INTO images (data) VALUES (%s)"
            cursor.execute(insert_query, (binary_data,))
            connection.commit()
            print("Image inserted successfully into the database")

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

finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("MySQL connection is closed")