nodejs-mysql | The wrapper of Node.js MySQL driver with Promise | Runtime Evironment library

I want to insert blob data in mariaDB using node js,I am using HeidiSQL to interact with mariaDB. 'users' table have two attributes 'user_email' and 'profile_photo'.

Similar Question

I found the following similar question but its not working in my case

NodeJS mySQL Insert Blob

Here is my code:

Summary: I'll start with a JSON schema to describe the expectation. Notice the roles with a nested array of objects and I'm looking for a "Smart query" that can fetch it one single query.

I am trying to setup a connection to my MySQL database and so far it is working, but when i run the nodejs application, and i don't read/update anything in my database the connection shuts down with:

Error: Connection lost The server closed the connection

So i searched on google and found this stackoverflow question. But i cannot get it to work, and i think it is because i am working with a class and not a function.

Below is the code i currently have:

I am a beginner on how to use mysql with nodejs

so I tried this basic tutorial on youtube and started to tweak it

I am trying to use async/await so I can begin a transaction in mysql

here's the code

I have searched all the answers related to this on stackoverflow but none seems to solve my issue. I was following this link to dockerize my nodejs-mysql app:

https://github.com/varunon9/getting-started-docker-mysql-nodejs#launching-nodejs-app-in-a-container

When I come to step-8 and do docker ps the container is not showing. I have checked the logs and it says "Error: Cannot find module 'express'". My run command is:

I'm new to node. I need to make a dependent dropdown menu which gets the address data of the selected user from another dropdown menu in the same page..The proplem is that the hole page is updated not only the second dropdown menu.. I think it's the same problem as dynamically dropdown in nodejs mysql, but it didn't help me much.

How can I switch the database after connecting to MySQL in nodejs using connection pool?

I used to use the normal connection with MySQL since it has some issue now I would like to use the connection pooling. But how can I change the database after creating a connection with MySQL?

Here is how I change the database:

This is the error--

I have a method in NodeJs using Express framework, in which I am iterating an array and making an update in a Mysql DB,
The Code receives a Connection object and a Post Body,
The Post Request Body is an Array of objects, of the data to be saved in the DB,
I am trying to loop the objects one by one and save them in the DB using an Update Query.

Now the strange part is, the code works only if it gets called twice immediately,
Ie. On testing I found out, I have to make the API request twice in order for the code to save the data.

I get the following error on the first API call -