msg.topic = "Insert into mytable(DeviceId,Line,outPIN,count,Time) values (?,?,?,?,?)"; msg.payload = [{"DeviceId": 1, "Line": 1, "outPIN": "GPIO1", "count": 15, "Time": "2018-09-23 08:14:45"}, {"DeviceId": 1, "Line": 1, "outPIN": "GPIO1", "count": 15, "Time": "2018-09-23 08:15:13"}, {"Dev…

Insert array of json data in mariadb

knolleary 9 October 2018 14:41 16

Which node-red node are you using to insert into mariadb? Does it even support passing in a array of data to do multiple inserts? I'm not aware of any node that does support doing that.

Topic		Replies	Views
Error: ER_PARSE_ERROR General	3	3380	8 October 2018
How to insert data with this string value and how to split it, i new for using node-red General	8	1401	31 October 2021
Mysql, mariadb INSERT fail - "msg.payload should be an object containing the query arguments." General	4	1363	26 July 2020
Json object save to mysql Error ER_PARSE_ERROR General	9	2166	16 November 2018
Newbie - msg.payload into SQL General	7	2288	13 December 2019

Insert array of json data in mariadb

Related topics