mysql数据库表如何加密

CREATE TABLE users (
  id INT PRIMARY KEY AUTO_INCREMENT,
  username VARCHAR(50),
  password VARBINARY(256)
);

INSERT INTO users (username, password)
VALUES ('user1', AES_ENCRYPT('password123', 'secretkey'));

SELECT id, username, AES_DECRYPT(password, 'secretkey') AS decrypted_password
FROM users
WHERE username = 'user1';

const crypto = require('crypto');
const mysql = require('mysql');

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

connection.connect();

const algorithm = 'aes-256-ctr';
const secretKey = 'secretkey';

function encrypt(text) {
  const cipher = crypto.createCipher(algorithm, secretKey);
  let encrypted = cipher.update(text, 'utf8', 'hex');
  encrypted += cipher.final('hex');
  return encrypted;
}

function decrypt(encryptedText) {
  const decipher = crypto.createDecipher(algorithm, secretKey);
  let decrypted = decipher.update(encryptedText, 'hex', 'utf8');
  decrypted += decipher.final('utf8');
  return decrypted;
}

const username = 'user1';
const password = 'password123';

const encryptedPassword = encrypt(password);

const sql = `INSERT INTO users (username, password) VALUES (?, ?)`;
const values = [username, encryptedPassword];

connection.query(sql, values, (error, results) => {
  if (error) throw error;
  console.log('Record inserted successfully');
});

connection.end();