deno mysql

import { Client } from "https://deno.land/x/mysql/mod.ts";

const client = await new Client().connect({
  hostname: "127.0.0.1",
  username: "root",
  password: "password",
  db: "my_database",
});

console.log("Connected to the database!");

try {
  const result = await client.execute("SELECT * FROM users WHERE id = ?", [userId]);
  console.log(result);
} catch (error) {
  console.error("Error executing query:", error);
}

import { Client } from "https://deno.land/x/mysql/mod.ts";

const client = await new Client().connect({
  hostname: "127.0.0.1",
  username: "root",
  password: "password",
  db: "my_database",
});

try {
  // 插入数据
  const insertResult = await client.execute(
    "INSERT INTO users (name, email) VALUES (?, ?)",
    ["John Doe", "john@example.com"]
  );
  console.log("Inserted row with ID:", insertResult.insertId);

  // 查询数据
  const selectResult = await client.execute("SELECT * FROM users");
  console.log("Users:", selectResult.rows);

  // 更新数据
  const updateResult = await client.execute(
    "UPDATE users SET email = ? WHERE id = ?",
    ["john_new@example.com", insertResult.insertId]
  );
  console.log("Updated rows:", updateResult.affectedRows);

  // 删除数据
  const deleteResult = await client.execute(
    "DELETE FROM users WHERE id = ?",
    [insertResult.insertId]
  );
  console.log("Deleted rows:", deleteResult.affectedRows);
} catch (error) {
  console.error("Database operation failed:", error);
} finally {
  await client.close();
}