使用nodeJs的MySQL嵌套Json对象

const mysql = require('mysql');

// 创建与MySQL数据库的连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

// 连接MySQL数据库
connection.connect();

// 创建表
const createTableQuery = `
  CREATE TABLE IF NOT EXISTS mytable (
    id INT AUTO_INCREMENT PRIMARY KEY,
    data JSON
  )
`;
connection.query(createTableQuery, (error, results, fields) => {
  if (error) throw error;
  console.log('Table created successfully');
});

// 插入数据
const jsonData = {
  name: 'John',
  age: 30,
  address: {
    city: 'New York',
    country: 'USA'
  }
};
const insertDataQuery = 'INSERT INTO mytable (data) VALUES (?)';
connection.query(insertDataQuery, [JSON.stringify(jsonData)], (error, results, fields) => {
  if (error) throw error;
  console.log('Data inserted successfully');
});

// 查询数据
const selectDataQuery = 'SELECT * FROM mytable';
connection.query(selectDataQuery, (error, results, fields) => {
  if (error) throw error;
  console.log(results);
});

// 关闭与MySQL数据库的连接
connection.end();