How to Fix the connection.query is not a function Error in Node.js with MySQL2 and Puppeteer

---

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---

Understanding the Problem

In your scenario, you were attempting to create a MySQL connection using the following code:

[[See Video to Reveal this Text or Code Snippet]]

While the intention is correct, the way you are handling the connection object might be leading to the issue.

Solution Steps

To resolve this issue, you can follow these organized steps to create a proper MySQL connection and execute your insert query successfully.

1. Use the Correct Method to Create MySQL Connection

Instead of using createConnection, it's best to use createConnection from mysql2/promise, which returns a promise-based connection object. Just ensure to use await for the connection creation.

2. Update Your Code for Database Insertion

Here’s the revised version of your code that addresses the issue:

[[See Video to Reveal this Text or Code Snippet]]

3. Handle Errors Gracefully

Make sure to wrap your connection and query related code in try/catch blocks. This captures any errors that may arise, allowing for graceful error handling and debugging.

4. Closing the Connection

Conclusion

Happy coding! If you run into further trouble or have any questions, feel free to drop a comment below!