Node.js Mysql Insert Object with On Dublicate

Question

How this query would be correct?

let newUser = {
    user_id:'123456',
    user_name:'someone'
    }

con.query('INSERT INTO users SET ? ON DUPLICATE KEY UPDATE ?', newUser, (err,rows) => {
        if(err) throw err;
    });

At the moment i get a syntax error after UPDATE

EDIT

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 '?' at line 1


 sql: "INSERT INTO users SET `user_id` = '', `user_name` = '' ON DUPLICATE KEY UPDATE ?"

TABLE STRUCTURE

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_Id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `user_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`,`user_Id`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

share the complete error log and the query generates

Ravi
– Ravi

2020-10-04 07:37:00 +00:00
Commented Oct 4, 2020 at 7:37 — Ravi
– Ravi, Commented Oct 4, 2020 at 7:37
Edited values are empty cause i deleted the real ones here

user13405446
– user13405446

2020-10-04 07:58:45 +00:00
Commented Oct 4, 2020 at 7:58 — user13405446
– user13405446, Commented Oct 4, 2020 at 7:58

Ravi · Accepted Answer · 2020-10-04 08:03:03Z

2

The number of question marks should be equal to the size of the array. You have to pass 2 params

let newUser = {
    user_id:'123456',
    user_name:'someone'
    }

con.query('INSERT INTO users SET ? ON DUPLICATE KEY UPDATE ?', [newUser, newUser], (err,rows) => {
        if(err) throw err;
    });

answered Oct 4, 2020 at 8:03

Ravi

2,2912 gold badges18 silver badges30 bronze badges

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

9 Comments

user13405446 Over a year ago

con.query('INSERT INTO users SET ? ON DUPLICATE KEY UPDATE ?', user, user (err,rows) => { ^^^^^^^^^^^^^^ SyntaxError: Malformed arrow function parameter list

Ravi Over a year ago

[newUser, newUser] is an array parameter con.query has 3 params 1. query, 2. input values, 3. callback

user13405446 Over a year ago

Okey got it so far :) but when i now change the user_name it makes a new entry. I only want having the user_id onces in my table

user13405446 Over a year ago

And it makes now everytime a new entry ... still when it has same values

Ravi Over a year ago

check with the primary key and unique key indexes ON DUPLICATE which check for those keys

|

Collectives™ on Stack Overflow

Node.js Mysql Insert Object with On Dublicate

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related