Alguém no grupo pode me dizer como posso obter dados do mysql?
Eu só preciso traçar um gráfico xy, onde x é tempo e y é ativado e desativado. um e zero.
Can anyone in the group tell me how I can get data from mysql?
I just need to chart xy where x is time and y is on and off. one and zero.
Thank you very much
@Kelva123456 have you looked at the node-red-node-mysql node? What have you tried so far?
I made a logic with the red node to write in the mysql database temperature and digital signals.
It's already working, now I need to report this data that's in the bank, and I have no idea how to do that.
In order to read the data from the database you will need to send a
select statement to a node-red-node-mysql and you will get the results output. The select statement will be something like:
select * from your-table-name