Hi, where to get infos about the Mysql node return after a SQL operation? I do a START TRANSACTION; INSERT INTO...; INSERT INTO...; COMMIT; Everything looks fine on the database side and I get the following output, but how to know from those data that it went fine rather than I got a error? a…

well, nice hint, but I was looking for directions to an error description table :grin:

Well in that case, you shoud go to the GitHub repositotary for the node and read thru the javascript of the node to see what it does :rofl: Seriously, in my mind the best thing to do is try it. It should take you 5 minutes and you will be able to look at the output and see if there is a difference.…

Well the node just reports back what mysql sends it - so really need to look at what sort of errors mysql would send... In the case you have - you send in 4 commands - and got an array of 4 results back (one for each command) - each has a warning count of 0 so I would l say it succeeded.

Thanks dceejay, will check this out.

Node-RED

Node-RED Forum

How to interpeter the output from a MySQL INSERT

Dashboard

zenofmud 29 March 2020 11:20 2

Why not try doing an insert with an error in it and see what you get out?

Topic		Replies	Views
MySQL (Mariadb) INSERT returns msg.payload = "[object Object]" General database	6	384	5 January 2023
MSQL Result Object General	1	468	20 June 2018
MySQL node not returning anything on database error Dashboard	9	777	14 March 2021
ER_PARSE_ERROR in mysql node General	4	2059	21 January 2022
mySQL: How to get the execution status of a query General	11	1718	2 November 2018

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

How to interpeter the output from a MySQL INSERT

Related topics