1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
// Copyright 2018-2022 the Deno authors. All rights reserved. MIT license.import mysql from "npm:mysql2/promise";import assert from "npm:assert";
async function main() {  // create the connection to database  const connection = await mysql.createConnection({    host: "localhost",    user: "root",    password: "root",    database: "test",  });
  await connection.execute(`DROP TABLE IF EXISTS pet;`);  await connection.execute(    `CREATE TABLE pet (name VARCHAR(20), species VARCHAR(20), age INT);`,  );  await connection.execute(    `INSERT INTO pet (name, species, age) values      ("Max", "dog", 3),      ("Charlie", "dog", 2),      ("Cooper", "dog", 1),      ("Buddy", "dog", 4),      ("Milo", "dog", 5),      ("Bear", "dog", 1),      ("Rocky", "dog", 4),      ("Duke", "dog", 3),      ("Tucker", "dog", 2),      ("Jack", "dog", 9),      ("Bella", "dog", 3),      ("Luna", "dog", 4),      ("Lucy", "dog", 3),      ("Daisy", "dog", 1),      ("Zoe", "dog", 2),      ("Lily", "dog", 7),      ("Lola", "dog", 11),      ("Bailey", "dog", 8),      ("Stella", "dog", 9),      ("Molly", "dog", 3);    `,  );  let results;  [results] = await connection.query(    'SELECT * FROM `pet` WHERE `name` = "Max" AND `age` > 1',  );  assert.deepStrictEqual(results, [    { name: "Max", species: "dog", age: 3 },  ]);  [results] = await connection.query("SELECT * FROM `pet` WHERE `age` > 5");  assert.deepStrictEqual(results, [    { name: "Jack", species: "dog", age: 9 },    { name: "Lily", species: "dog", age: 7 },    { name: "Lola", species: "dog", age: 11 },    { name: "Bailey", species: "dog", age: 8 },    { name: "Stella", species: "dog", age: 9 },  ]);  [results] = await connection.query(    "SELECT * FROM `pet` WHERE `name` = ? AND `age` > ?",    ["Max", 1],  );  assert.deepStrictEqual(results, [    { name: "Max", species: "dog", age: 3 },  ]);  connection.close();}
main();