如何使用typescript / mysql包将blob插入到mysql中

npm install typescript mysql

import * as fs from 'fs';
import * as mysql from 'mysql';

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect((error) => {
  if (error) {
    console.error('Failed to connect to MySQL:', error);
    return;
  }
  console.log('Connected to MySQL!');
});

const blobData = fs.readFileSync('path_to_blob_file');

const insertQuery = 'INSERT INTO your_table (blob_column) VALUES (?)';

connection.query(insertQuery, [blobData], (error, results) => {
  if (error) {
    console.error('Failed to insert Blob:', error);
    return;
  }
  console.log('Blob inserted successfully!');
});

connection.end((error) => {
  if (error) {
    console.error('Failed to close MySQL connection:', error);
    return;
  }
  console.log('MySQL connection closed!');
});