使用NodeJS将JSON插入到MySQL JSON列格式中

const mysql = require('mysql2');

// 创建MySQL连接池
const pool = mysql.createPool({
  host: 'your_host',
  user: 'your_user',
  password: 'your_password',
  database: 'your_database',
});

// 从连接池中获取连接
const connection = pool.getConnection((err, connection) => {
  if (err) throw err;
  console.log('Connected to MySQL database!');
});

const jsonData = {
  name: 'John Doe',
  age: 30,
  email: 'johndoe@example.com',
};

const jsonString = JSON.stringify(jsonData);

const sql = `INSERT INTO your_table (json_column) VALUES ('${jsonString}')`;

connection.query(sql, (err, result) => {
  if (err) throw err;
  console.log('JSON data inserted successfully!');
});

connection.release();