Mqtt input to an sql DB

General
, ,
1

Hello!
I am having trouble importing the mqtt input of a published message to a table in my sql Database
How this it build mqtt input to a function and then to the sql server?
Mqtt -> template -> sql server ?
And how the mqtt message is gonna be formatted all information to a single publish
or splitted?

Mqtt input arrives on a textbox and i can display them but my whole thing is to be in position to insert them to the Sql server

Soon i Will provide screenshots about it!
thanks

2

The queries needs to be the msg.topic (for most sql BD nodes).

What flavor of sql DB are you using? (mysql, sqllight.......)

If you post a bit more information, like your json from the mqtt node, do you want to insert or select data, what your DB looks like etc. we might be able to assist you.

3

Have a Nice Day. Hope you're fine!
Im going to upload The flow after i finish from the office.
Im using mysql and the trouble im getting is to theinsert query.
The DB schema consists of a table with 5 columns
Id State Current Email Timestamp.
The Mqtt message that is published is a string and i want to insert the message to the table.
Thats a brief description
Thanks.

4

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.