mysql2_promise_connection_and_parameterized_query_typescript.ts

1import mysql, { ConnectionOptions, ResultSetHeader, RowDataPacket } from 'mysql2/promise';
2
3// Connection configuration
4const access: ConnectionOptions = {
5  host: 'localhost',
6  user: 'root',
7  password: 'password',
8  database: 'test'
9};
10
11async function main() {
12  // Create the connection
13  const connection = await mysql.createConnection(access);
14
15  try {
16    // Execute a simple query
17    const [rows] = await connection.execute<RowDataPacket[]>(
18      'SELECT * FROM `users` WHERE `name` = ? AND `age` > ?',
19      ['Morty', 14]
20    );
21
22    console.log('Query Results:', rows);
23
24    // Example of an INSERT/UPDATE using ResultSetHeader
25    // const [result] = await connection.execute<ResultSetHeader>(
26    //   'INSERT INTO `users` (name, age) VALUES (?, ?)',
27    //   ['Rick', 70]
28    // );
29    // console.log('Inserted ID:', result.insertId);
30
31  } catch (err) {
32    console.error('Database error:', err);
33  } finally {
34    // Close the connection
35    await connection.end();
36  }
37}
38
39main();