How to create a Nodejs MySQL execute query for values that might not exist

Question

I'm inserting values into a MySQL database using Nodejs mysql2 library.

Here is an example of a prepared statement:

await conn.execute(
    'INSERT INTO Friends (id, user, name, gender) VALUES (UUID(), ?, ?, ?)',
    [ user, body.name, body.gender ]
);

How can I achieve the above if sometimes the body.gender value is not set? I want several attributes in the http request to be optional and insert all allowed values that have been sent in the http request into the database.

The above code gives an error if I leave body.gender out of the http request.

mohammad javad ahmadi · Accepted Answer · 2021-01-20 05:14:41Z

1

If there is no some data in body or not sending some data from the client to register in the database, you have to put a null value for that row in that column. You can use this JavaScript feature to do this:

await conn.execute(
    'INSERT INTO Friends (id, user, name, gender) VALUES (UUID(), ?, ?, ?)',
    [ user || null, body.name || null, body.gender || null ]
);

Using this possibility, in the absence of any of the data sent in the body, its value is undefined and the value of null is placed in the query.

edited Jan 20, 2021 at 5:14

answered Jan 20, 2021 at 5:08

mohammad javad ahmadi

2,0811 gold badge14 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create a Nodejs MySQL execute query for values that might not exist

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related