MySQL—mysql connection

Run a SQL INSERT statement by opening and closing a connection to Cloud SQL for MySQL by using the Node.js mysql module.

Documentation pages that include this code sample

To view the code sample used in context, see the following documentation:

Code sample

Node.js

try {
  const stmt = 'INSERT INTO votes (time_cast, candidate) VALUES (?, ?)';
  // Pool.query automatically checks out, uses, and releases a connection
  // back into the pool, ensuring it is always returned successfully.
  await pool.query(stmt, [timestamp, team]);
} catch (err) {
  // If something goes wrong, handle the error in this section. This might
  // involve retrying or adjusting parameters depending on the situation.
  // ...
}

What's next

To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.