如何把图片保存到mysql数据库中

const express = require('express');
const multer  = require('multer');
const mysql = require('mysql');

const app = express();
const upload = multer({ dest: 'uploads/' });

// MySQL连接配置
const connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'your_username',
  password : 'your_password',
  database : 'your_database'
});

// 处理文件上传
app.post('/upload', upload.single('image'), (req, res) => {
  // 获取上传的图片文件
  const imageFile = req.file;

  // 将图片文件保存到MySQL数据库中
  const sql = 'INSERT INTO images (name, data) VALUES (?, ?)';
  connection.query(sql, [imageFile.originalname, imageFile.buffer], (error, results, fields) => {
    if (error) throw error;
    res.send('Image saved successfully!');
  });
});

// 启动服务器
app.listen(3000, () => {
  console.log('Server started on port 3000');
});

CREATE TABLE images (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255) NOT NULL,
  data LONGBLOB NOT NULL
);