如何在MySql数据库中存储项目列表？

CREATE TABLE projects (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    description TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

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 project = {
    name: 'Project 1',
    description: 'This is project 1'
};

connection.query('INSERT INTO projects SET ?', project, (err, result) => {
    if (err) throw err;
    console.log('Project inserted successfully');
    console.log(result);
});

// 关闭数据库连接
connection.end((err) => {
    if (err) throw err;
    console.log('Disconnected from MySQL database');
});