如何修改网页投票数据库

CREATE TABLE votes (
    id INT PRIMARY KEY,
    option VARCHAR(255),
    count INT
);

UPDATE votes
SET count = count + 10
WHERE option = 'Option A';

const mysql = require('mysql');

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

connection.connect();

const option = 'Option A';
const increment = 10;

const sql = `UPDATE votes SET count = count + ${increment} WHERE option = '${option}'`;

connection.query(sql, (error, results, fields) => {
    if (error) throw error;
    console.log('Vote count updated successfully');
});

connection.end();