# Modbus to mySQL flow suggestions

**URL:** <https://discourse.nodered.org/t/modbus-to-mysql-flow-suggestions/98531>\
**Category:** General\
**Tags:** modbus, mysql\
**Created:** [5 August 2025 19:18 UTC](https://discourse.nodered.org/t/modbus-to-mysql-flow-suggestions/98531 "2025-08-05T19:18:38Z")\
**Posts on this page:** 1\
**Showing post:** 28

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [7 August 2025 06:33 UTC](https://discourse.nodered.org/t/modbus-to-mysql-flow-suggestions/98531/28 "2025-08-07T06:33:40Z")

</div>

this thread may interest you...

> [@Building a dynamic msg.topic to create a mysql insert statement](https://discourse.nodered.org/t/building-a-dynamic-msg-topic-to-create-a-mysql-insert-statement/98024/14):
>
> Yes, understood, really useful. I even got it to work without naming the field names before VALUES clause, as i am updating ALL the fields. msg.topic = "INSERT INTO cc VALUES (:rdate, :totalcases, :totalcl, :caseperman, :costpercase, :cpm, :cpc)"; msg.payload = { "totalcases": 1234, "rdate": "2025-07-03", "caseperman": 49, "totalcl": 25, "costpercase": 39, "cpc": 25, "cpm": 52, } EDIT: Extremely Sorry @fogmajor for hijacking your thread. I will stop.

---

_[View the full topic](https://discourse.nodered.org/t/modbus-to-mysql-flow-suggestions/98531)._