Node.js mySQL syntax error when posting data

Question

I'm new to Node.js and servers in general and have just started trying to implement a database into my server. I have the mySQL database and table set up with the server connecting to the database and the server beginning to process the SQL query, however it breaks the query due to a syntax error within my INSERT, I've been looking at the forums and have changed my code a couple of times with no luck... Please help if you can see where I've gone wrong, Thank you!

router.post('/', (req, res, next) => {
    console.log(req.name);
    const imageJSON = {
        //attributes of item that server will request (more important for db
        name: req.body.name,
        image: req.body.image
    };
    //console.log(req.body.image);

    res.status(201).json({
        message: imageJSON
    });
    connection.connect(function(err){
        if(!err) {
            console.log("Database is connected ... nn");
        } else {
            console.log("Error connecting database ... nn");
        }
    });
    var post = {id: 1, name: req.body.name, image: req.body.image};
    connection.query('INSERT INTO "images" ("id", "name", "image") VALUES ?', post,
        function(err, rows, fields) {
            connection.end();
            if (!err)
                console.log('The solution is: ', rows);
            else
                console.log('Error while performing Query.', err);
        });
    //connection.end();
});

You should not use quote around sql object name (table and column name ) — ScaisEdge
– ScaisEdge, Commented Mar 31, 2018 at 18:19

kimobrian254 · Accepted Answer · 2018-03-31 18:31:49Z

1

Try this:

var post = {id: 1, name: req.body.name, image: req.body.image};
var query = connection.query('INSERT INTO images SET ?', post, function 
   (error, rows, fields) {
      // ... operation on result
});

answered Mar 31, 2018 at 18:31

kimobrian254

5773 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Node.js mySQL syntax error when posting data

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