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…

Do you mean guide you with the SQL queries that you need?

Not exactly, but to perform SQL queries with related tables mysql

To perform SQL queries with related tables you need to generate the correct SQL that specifies the relationships between the tables. Google for SQL Tutorial, there are thousands available. If English is not your native language then you may be able to find one in your language.

oohh I was referring to related tables (mysql) that perform queries in node red, but I will look for information; Thanks for the help

[image] Tefita: related tables (mysql) that perform queries in node red, You don't perform queries in node red. You first need to know what query you want, then you design your flow so that the query you want is built and is passed to the database to run the query, then the result is passed …

@Tefita - When you add a person to the pacientes table, the idpacientes is automatically generated. If you want to add a row to the datos table and link it to this table, you must provide the value that is now in the row in the pacientes table for this person. You need to retreive the row from the p…

Thank you and I will take your advice.

Hi I have solved the problem of the relational tables in mysql, but now the inconvenience that I want to do the following is presented: Enter the patient's data (name, surname, CEDULA, age, sex) that are stored in a table called "patients", insert the patient's data with a button, if I have manag…

[image] Tefita: In the data table there are other attributes (tamb, tcorp, ....) that come from an mqtt node. How do you know what patient the MQTT data is for?

Node-RED

Node-RED Forum

Node red and relational database (mysql)?

General

Tefita 16 January 2019 18:18 32

Thank you very much, I will look for more mysql information from related tables.

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

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.

Node red and relational database (mysql)?

Related topics