# N queries in 1 Node mysql

**URL:** <https://discourse.nodered.org/t/n-queries-in-1-node-mysql/77565>\
**Category:** General\
**Created:** [14 April 2023 13:02 UTC](https://discourse.nodered.org/t/n-queries-in-1-node-mysql/77565 "2023-04-14T13:02:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Safouene28](https://avatars.discourse-cdn.com/v4/letter/s/b77776/32.png) [@Safouene28](https://discourse.nodered.org/u/Safouene28)\
**Post date:** [14 April 2023 13:02 UTC](https://discourse.nodered.org/t/n-queries-in-1-node-mysql/77565/1 "2023-04-14T13:02:23Z")

</div>

Hello Everyone, I Have I have 4 queries connected to 1 node-red-contrib-stackhero-mysql , The queries is executed at the same time with an inject node , my question is how can i join them and make sure that i received the data of the 4 queries?

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [14 April 2023 13:48 UTC](https://discourse.nodered.org/t/n-queries-in-1-node-mysql/77565/2 "2023-04-14T13:48:48Z")

</div>

I don't have the stackhero mysql node but it may work in the same way as the more familiar node-red-node-mysql.

Set msg.tag on each query before feeding them to SQL.  
This value is preserved through the SQL node so you can use it to join the 4 outputs into a single combined message.

 ![Untitled 4](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/5/1576e29766671cc3c63f47cfdee83f583afd381b.jpeg)

```auto
[{"id":"40e414cd0c16085a","type":"tab","label":"Flow 2","disabled":false,"info":"","env":[]},{"id":"aeccf2df7499070a","type":"debug","z":"40e414cd0c16085a","name":"debug 293","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":710,"y":140,"wires":[]},{"id":"5b795a5e7be3568e","type":"mysql","z":"40e414cd0c16085a","mydb":"2381cb15.b563bc","name":"select","x":450,"y":140,"wires":[["da49e39e282d92ed"]]},{"id":"da49e39e282d92ed","type":"join","z":"40e414cd0c16085a","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"tag","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"4","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":570,"y":140,"wires":[["aeccf2df7499070a"]]},{"id":"bbfe7bbef5634f07","type":"change","z":"40e414cd0c16085a","name":"msg.tag=One","rules":[{"t":"set","p":"tag","pt":"msg","to":"One","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":280,"y":80,"wires":[["5b795a5e7be3568e"]]},{"id":"bcbe897d1eefd737","type":"change","z":"40e414cd0c16085a","name":"msg.tag=Two","rules":[{"t":"set","p":"tag","pt":"msg","to":"Two","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":280,"y":120,"wires":[["5b795a5e7be3568e"]]},{"id":"e9965f314711aced","type":"change","z":"40e414cd0c16085a","name":"msg.tag=Three","rules":[{"t":"set","p":"tag","pt":"msg","to":"Three","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":280,"y":160,"wires":[["5b795a5e7be3568e"]]},{"id":"16a90e4d41f1ccfe","type":"change","z":"40e414cd0c16085a","name":"msg.tag=Four","rules":[{"t":"set","p":"tag","pt":"msg","to":"Four","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":280,"y":200,"wires":[["5b795a5e7be3568e"]]},{"id":"2381cb15.b563bc","type":"MySQLdatabase","name":"db","host":"127.0.0.1","port":"3306","db":"espresso","tz":"","charset":"UTF8"}]

```

---

<div class="post-metadata">

**Author:** ![Safouene28](https://avatars.discourse-cdn.com/v4/letter/s/b77776/32.png) [@Safouene28](https://discourse.nodered.org/u/Safouene28)\
**Post date:** [14 April 2023 14:12 UTC](https://discourse.nodered.org/t/n-queries-in-1-node-mysql/77565/3 "2023-04-14T14:12:59Z")

</div>

That's what I need 😃 , Thank you very much 😃 😃

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [28 April 2023 14:13 UTC](https://discourse.nodered.org/t/n-queries-in-1-node-mysql/77565/4 "2023-04-28T14:13:35Z")

</div>

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