Node.js Update Table With Array In Mysql

I have this table. My datas are below to put this table above. buffer= [{deviceId: 000002, input2:false, input3:false, input4:false, input5:false, input6:false, input7:false, inpu

Solution 1:

I found solution of my problem. need to use

insertinto TABLENAME(key, column1, column2, ...) values (?),(?),... on duplicate key update column1=value(column1), column2=value(column2), ...;

but there is one detail, that is key column have to be unique index