mysql能储存图片

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

import mysql.connector

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="mydatabase"
)

cursor = db.cursor()

# 插入图片路径
sql = "INSERT INTO images (name, path) VALUES (%s, %s)"
val = ("example.jpg", "/path/to/example.jpg")
cursor.execute(sql, val)

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

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

import mysql.connector

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="mydatabase"
)

cursor = db.cursor()

# 读取图片文件
with open('/path/to/example.jpg', 'rb') as file:
    binary_data = file.read()

# 插入二进制数据
sql = "INSERT INTO images (name, image) VALUES (%s, %s)"
val = ("example.jpg", binary_data)
cursor.execute(sql, val)

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