mysql2_promise_typed_query_with_connection_pool_typescript.ts

1import mysql, { ResultSetHeader, RowDataPacket } from 'mysql2/promise';
2
3async function main() {
4  // Create the connection to database
5  const connection = await mysql.createConnection({
6    host: 'localhost',
7    user: 'root',
8    database: 'test',
9  });
10
11  // Example of a typed SELECT query
12  interface User extends RowDataPacket {
13    id: number;
14    name: string;
15  }
16
17  const [rows] = await connection.query<User[]>('SELECT * FROM `users` WHERE `name` = ?', ['John']);
18  console.log(rows); // rows is inferred as User[]
19
20  // Example of an INSERT query
21  const [result] = await connection.execute<ResultSetHeader>(
22    'INSERT INTO `users` (name) VALUES (?)',
23    ['Rick']
24  );
25  console.log(result.insertId); // result is inferred as ResultSetHeader
26
27  await connection.end();
28}
29
30main().catch(console.error);