Why my database displays undefined even I inserted data in POSTMAN?

Solution 1:

Can you make sure that the following is done?

1. The content-type header in the request has to be application/json

2. Use body-parser (or similar libraries) to parse JSON payloads -> You can print the req.body to validate this.

3. If you can confirm that the values are accessible, I would suggest escaping query values as mentioned in https://github.com/mysqljs/mysql#escaping-query-values (or in any mysql library that you use) - especially since it is a DML query.

(Also I assume that the fieldnames used in the query match with the ones in the database and are of the right datatype.)