# Results in the MySQL database are all 0 for all columns

**URL:** <https://discourse.nodered.org/t/results-in-the-mysql-database-are-all-0-for-all-columns/86857>\
**Category:** General\
**Created:** [30 March 2024 01:14 UTC](https://discourse.nodered.org/t/results-in-the-mysql-database-are-all-0-for-all-columns/86857 "2024-03-30T01:14:01Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [30 March 2024 08:23 UTC](https://discourse.nodered.org/t/results-in-the-mysql-database-are-all-0-for-all-columns/86857/3 "2024-03-30T08:23:58Z")

</div>

> [@Sobri](#):
>
> why the results in the MySQL database are all 0 for all columns

Because that is what you have told it to do. I would suggest you add a `debug` node (set to display the complete msg object) to the output of the `function` node just before your `mysql` node and run your code.

Then look at the output of the debug node and read the 'Help' information of the `mysql` node to see what you have done.

With one line of code and two images, that is the best I can do to help you at this point.

`[This topic has been closed since it is a duplicate]`

---

_[View the full topic](https://discourse.nodered.org/t/results-in-the-mysql-database-are-all-0-for-all-columns/86857)._