如何使用nodejs更新mysql json数组

npm install mysql

const mysql = require('mysql');

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

connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to MySQL database');
});

const updateQuery = 'UPDATE your_table SET your_json_column = JSON_SET(your_json_column, "$[0].key", "new_value") WHERE id = your_id';

connection.query(updateQuery, (err, result) => {
  if (err) throw err;
  console.log('JSON array updated successfully');
});

connection.end((err) => {
  if (err) throw err;
  console.log('Disconnected from MySQL database');
});