在用户提交表单时创建自动递增的id

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(50),
  email VARCHAR(50)
);

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'username',
  password: 'password',
  database: 'database_name'
});

connection.connect();

// 用户提交表单时的处理逻辑
app.post('/submit-form', (req, res) => {
  const { name, email } = req.body;
  
  const query = 'INSERT INTO users (name, email) VALUES (?, ?)';
  connection.query(query, [name, email], (error, results) => {
    if (error) throw error;
    
    // 插入成功后，results.insertId 就是自动生成的自增id
    const userId = results.insertId;
    
    res.json({ success: true, userId });
  });
});