mysql语句存储图片

-- 设置数据库和表的字符集为utf8mb4
ALTER DATABASE your_database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 设置字段的字符集为utf8mb4
ALTER TABLE your_table_name MODIFY your_blob_column LONGBLOB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 创建表
CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    image_data LONGBLOB
);

-- 插入图片数据
INSERT INTO images (name, image_data) VALUES ('example.jpg', LOAD_FILE('/path/to/example.jpg'));

-- 查询图片数据
SELECT name, image_data FROM images WHERE id = 1;

-- 创建表
CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    file_path VARCHAR(255)
);

-- 插入文件路径
INSERT INTO images (name, file_path) VALUES ('example.jpg', '/path/to/example.jpg');

-- 查询文件路径
SELECT name, file_path FROM images WHERE id = 1;