@types/mysql

Connecting to a MySQL database

This code demonstrates how to connect to a MySQL database using the mysql package with TypeScript types provided by @types/mysql. It includes type checking for the connection options.

import * as mysql from 'mysql';
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'yourusername',
  password: 'yourpassword',
  database: 'mydb'
});
connection.connect(err => {
  if (err) throw err;
  console.log('Connected!');
});

Performing a query

This example shows how to perform a basic SQL query to select all records from the 'users' table. The results are logged to the console. The @types/mysql package ensures that the function parameters and return types are correctly typed.

connection.query('SELECT * FROM users', (err, results) => {
  if (err) throw err;
  console.log(results);
});

Closing the connection

This snippet illustrates how to close the database connection properly. It uses the end method provided by the mysql package, with type safety ensured by @types/mysql.

connection.end(err => {
  if (err) return console.log('error:' + err.message);
  console.log('Close the database connection.');
});