# Loop query array and send to mysql

**URL:** <https://discourse.nodered.org/t/loop-query-array-and-send-to-mysql/52199>\
**Category:** General\
**Created:** [14 October 2021 07:14 UTC](https://discourse.nodered.org/t/loop-query-array-and-send-to-mysql/52199 "2021-10-14T07:14:03Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ketpa](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ketpa/32/42496_2.png) [@ketpa](https://discourse.nodered.org/u/ketpa)\
**Post date:** [14 October 2021 07:14 UTC](https://discourse.nodered.org/t/loop-query-array-and-send-to-mysql/52199/1 "2021-10-14T07:14:03Z")

</div>

I have array of query  
 ![obraz](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/6/560e4f2caec429bc0898ebfec1cd5e4d8107b097.png)  
I try sent msg.topic to mysql like this  
 ![obraz](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/8/0830c72d0997e706e162b923fc0de733de5d899e.png)  
but it send me only one query  
 ![obraz](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/a/aacc3373ff8d8f4ee0eef75fbbd12e2f531a9ce1.png)  
How to loop query as msg.topic and send to mysql ?

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [14 October 2021 08:07 UTC](https://discourse.nodered.org/t/loop-query-array-and-send-to-mysql/52199/2 "2021-10-14T08:07:49Z")

</div>

you can have only 1 return statement in a function.

I assume that `query.length` comes from `msg.query.length`.  
But in order to send messages within a loop use `node.send({ msg.topic: query[i] })`  
and add `return null` at the bottom

To make it shorter:

```auto
msg.query.forEach(query => node.send({topic: query}))
return null

```

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [14 October 2021 08:35 UTC](https://discourse.nodered.org/t/loop-query-array-and-send-to-mysql/52199/3 "2021-10-14T08:35:13Z")

</div>

> [@bakman2](#):
>
> you can have only 1 return statement in a function.

Not exactly true, you can have many but as soon as one is executed the function node will exit and the flow will move to the next node.

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [14 October 2021 08:37 UTC](https://discourse.nodered.org/t/loop-query-array-and-send-to-mysql/52199/4 "2021-10-14T08:37:21Z")

</div>

Yes sorry indeed that is a better formulation; return = exit

Kind of weird, because I use that all the time in "guard clauses"

---

<div class="post-metadata">

**Author:** ![ketpa](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ketpa/32/42496_2.png) [@ketpa](https://discourse.nodered.org/u/ketpa)\
**Post date:** [14 October 2021 12:14 UTC](https://discourse.nodered.org/t/loop-query-array-and-send-to-mysql/52199/5 "2021-10-14T12:14:01Z")

</div>

> Yes sorry indeed that is a better formulation; return = exit  
> I try 'return exit' 'exit' 'return = exit' and its fault.  
> What is the correct?

---

<div class="post-metadata">

**Author:** ![Buckskin](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@Buckskin](https://discourse.nodered.org/u/Buckskin)\
**Post date:** [14 October 2021 18:19 UTC](https://discourse.nodered.org/t/loop-query-array-and-send-to-mysql/52199/6 "2021-10-14T18:19:40Z")

</div>

It just means that any `return` statement will exit the function and / or function node

---

<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 October 2021 18:19 UTC](https://discourse.nodered.org/t/loop-query-array-and-send-to-mysql/52199/7 "2021-10-28T18:19:53Z")

</div>

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