mysql如何上传图片

import os
import mysql.connector

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)
cursor = db.cursor()

# 上传图片
file_path = "path/to/your/image.jpg"
file_name = os.path.basename(file_path)

# 将图片保存到文件系统
with open(file_path, 'rb') as file:
    image_data = file.read()

# 将图片路径保存到数据库
sql = "INSERT INTO images (file_name, file_path) VALUES (%s, %s)"
cursor.execute(sql, (file_name, file_path))
db.commit()

cursor.close()
db.close()

import mysql.connector

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)
cursor = db.cursor()

# 上传图片
file_path = "path/to/your/image.jpg"

# 将图片的二进制数据直接存储到MySQL
with open(file_path, 'rb') as file:
    image_data = file.read()

sql = "INSERT INTO images (file_name, image_data) VALUES (%s, %s)"
cursor.execute(sql, (os.path.basename(file_path), image_data))
db.commit()

cursor.close()
db.close()