MySQL error with insert function in Nodejs (Javascript)

Question

Im trying to use insert function and Im getting all the time an error :( Im trying to insert into user table a name of the user

My function:

 function insert(tableName, toField, value){
    connection.connect();
    var queryString = "insert into "+tableName+" ("+toField+") 
    select "+connection.escape(value)+"";    

    connection.query(queryString, function(err) {
        if (err) throw err;
    });     
}

and in the main code:

var name ="Anna";
Helpers.insert('user', 'name', name);

Everytime I get an error:

Uncaught exception: Error: ER_PARSE_ERROR: 
You have an error in your SQL syntax; check the manual 
that corresponds to your MySQL server version for the right syntax 
to use near ''user' ('name') select 'Anna'' at line 1
Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the 
right syntax to use near ''user' ('name') select 'Anna'' at line 1

Anna K · Accepted Answer · 2017-04-30 17:03:10Z

1

I made it :) Thank for your help!!

 function insert(tableName, toField, value){
    connection.connect();
    var queryString = "INSERT INTO  "+tableName+" ("+toField+") VALUES ("+connection.escape(value)+")";    

    connection.query(queryString, function(err) {
        if (err) throw err;
    });     
}

answered Apr 30, 2017 at 17:03

Anna K

1,7825 gold badges28 silver badges50 bronze badges

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

Comments

Srihari Karanth · Accepted Answer · 2017-04-30 16:17:43Z

0

You need to add Values() which is missing,

var queryString = "insert into "
    +connection.escape(tableName)+" ("+connection.escape(toField)+")
    Values (" + connection.escape(value)+")";

answered Apr 30, 2017 at 16:17

Srihari Karanth

2,1772 gold badges26 silver badges40 bronze badges

1 Comment

Anna K Over a year ago

The same ;( Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''user' ('name')values 'Anna'' at line 1

Marian · Accepted Answer · 2017-04-30 16:28:24Z

0

    var queryString = 
        "INSERT INTO " + connection.escapeId(tableName)

You could use connection.escapeId to escape an identifier (as opposed to a value).

answered Apr 30, 2017 at 16:28

Marian

4,0992 gold badges29 silver badges38 bronze badges

3 Comments

Anna K Over a year ago

still the same ;( Uncaught exception: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Anna' at line 1

Marian Over a year ago

@AnnaK could you do var query = connection.query(...) and then console.log(query.sql)?

Anna K Over a year ago

insert into user (name) values Anna That I get from console.log(queryString). Is it strange. Isn't? Because it looks ok

Collectives™ on Stack Overflow

MySQL error with insert function in Nodejs (Javascript)

3 Answers 3

Comments

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related