# MySQL Query and Process Select

**URL:** <https://discourse.nodered.org/t/mysql-query-and-process-select/39722>\
**Category:** General\
**Created:** [25 January 2021 18:25 UTC](https://discourse.nodered.org/t/mysql-query-and-process-select/39722 "2021-01-25T18:25:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![CybrPimp](https://avatars.discourse-cdn.com/v4/letter/c/a698b9/32.png) [@CybrPimp](https://discourse.nodered.org/u/CybrPimp)\
**Post date:** [25 January 2021 18:25 UTC](https://discourse.nodered.org/t/mysql-query-and-process-select/39722/1 "2021-01-25T18:25:58Z")

</div>

Ok, guys working through the problems as a new Node-Red user with the help of several. Thanks to everyone.

So I have a MySQL Task setup and showing connected, but I'm not sure how to Query the database and process those records on the next downsteam task to process for each of the returned records.

I have the Node-Red-Node-MySQL installed and I'm really not sure how to get the query setup and other basic issues.

Can someone offer some guidance?

---

<div class="post-metadata">

**Author:** ![aderici](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/aderici/32/37279_2.png) [@aderici](https://discourse.nodered.org/u/aderici)\
**Post date:** [25 January 2021 19:55 UTC](https://discourse.nodered.org/t/mysql-query-and-process-select/39722/2 "2021-01-25T19:55:32Z")

</div>

hi,

I am using a function node to achieve mysql query capability but basically you provide your query and the parameters (if you are using parameterised query) and the mysql node executes it and provides the results to the next node

---

<div class="post-metadata">

**Author:** ![CybrPimp](https://avatars.discourse-cdn.com/v4/letter/c/a698b9/32.png) [@CybrPimp](https://discourse.nodered.org/u/CybrPimp)\
**Post date:** [25 January 2021 20:39 UTC](https://discourse.nodered.org/t/mysql-query-and-process-select/39722/3 "2021-01-25T20:39:58Z")

</div>

Do you have any code to share or link to examples?

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [25 January 2021 21:05 UTC](https://discourse.nodered.org/t/mysql-query-and-process-select/39722/4 "2021-01-25T21:05:17Z")

</div>

The node's readme shows the basic principles - [node-red-node-mysql (node) - Node-RED](https://flows.nodered.org/node/node-red-node-mysql)

Also the flows site has some flows that may be useful as examples. [Library - Node-RED](https://flows.nodered.org/search?term=mysql&type=flow)

---

<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:** [26 March 2021 21:06 UTC](https://discourse.nodered.org/t/mysql-query-and-process-select/39722/5 "2021-03-26T21:06:05Z")

</div>

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