Column name uniquekey is not working

Asked Sep 22 '16 at 10:27

Active Sep 22 '16 at 10:35

Viewed 27 times

I try to insert data using Node.js and MySql. I have database table name my_todo it has one column name uniquekey when I insert data its give following error.

{ [Error: ER_BAD_FIELD_ERROR: Unknown column '1SPwxbFzXVZFPAx' in 'field list']
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sqlState: '42S22',
  index: 0 }

Here is my code

    var unik = "1SPwxbFzXVZFPAx";
    con.query("insert into my_todo(uniquekey,creator_id,todo) values("+unik+",1,this is my todo)", function (err, result){                                                                      
    if(err){ console.log(err);}
});

edited Sep 22 '16 at 10:35

Martin

22,212
11
70
132

asked Sep 22 '16 at 10:27

KD Makwana

Have you googled error 1054? – Martin Sep 22 '16 at 10:29
its take column name as my uniquekey value. please give some suggestion. – KD Makwana Sep 22 '16 at 10:30
yes, but did'n't find out. – KD Makwana Sep 22 '16 at 10:30
Add that detail in to your queston, you will get a lot more helpful responses if people know what research and things you've already tried `:-)` – Martin Sep 22 '16 at 10:31
I would suggest encasing the string values (`this is my todo` and `unik`) in single quotes. But I do not know the syntax for node.js specifically :-/ – Martin Sep 22 '16 at 10:32
i also tried that. – KD Makwana Sep 22 '16 at 10:34
again, ***edit*** and state that on your question so we know what you've tried and what you've not. – Martin Sep 22 '16 at 10:35
Please use prepared statements. You're SQL-injecting your own code ;-) You have usage examples in the linked question. – Álvaro González Sep 22 '16 at 10:38

Column name uniquekey is not working

0 Answers0