Greetings to all. I perform the registration of some data (name, surname, etc) and store them in a mysql table called patients, but this table is related to another named data and have the attribute idpacientes in the two tables, as observe in the figure, when I enter a patient this generates an in…

Let me ask Nick's question another way Will there ever be more than one paitent having the device(s) that send the mqtt attached? If so, since the data is send automatically, what will indicate in the MQTT msg which paitent the msg is from?

Thanks for your help, but there is only one device that sends the mqtt topics (tamb, tcorp ...).

@Tefita It is a very simple question that you have not answered. When a message arrives on an MQTT topic, how does your flow know what patient it is for?

The flow does not know that, I just enter the patient's data manually so that it is stored in the "patients" table, and the CEDULA attribute is in the "data" relational table.

Ok - so at this point I don't know if you are still asking a question here.

Thanks for answering what I really want is that the attribute "CEDULA" continue to be stored with the data that comes from the topics but this only happens once. Is it necessary for me to open a new forum debate?

Please do not open another topic. [image] Tefita: I really want is that the attribute "CEDULA" continue to be stored with the data that comes from the topics but this only happens once. I'm not really clear on what you mean. With your current flow, what do you get in the database? Can you s…

Thank you for your answers: I am looking for continuously updating rows Tamb, Tcorp .... Ptcorp every time a new data arrives. But the data in the row "CEDULA" is kept and stored together with the other data, and this is updated only when a different attribute "CEDULA" is entered.

Node red and relational database (mysql)?

General

Tefita 31 January 2019 20:57 47

I get these results in the Database (Patients table and data table):

I add the debug messages of each mysql node. bd3 bd4

But later the device keeps sending topics and I look for these to be stored continuously, but they are only stored once because I enter the attribute "CEDULA" only once.

Topic		Replies	Views
Read from mysql db Dashboard	54	17580	23 December 2018
Generate SQL statement from 2 mqtt messages General	42	1083	20 July 2020
How can i create a table from a DB? General	9	1168	18 June 2020
PLC machine data sent Via MQTT to Node Red Then to SQL Database General	26	711	30 December 2024
Connection with database error General	115	2858	3 August 2020

Node red and relational database (mysql)?

Related topics