# 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:** 1

<div class="post-metadata">

**Author:** ![Sobri](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@Sobri](https://discourse.nodered.org/u/Sobri)\
**Post date:** [30 March 2024 01:14 UTC](https://discourse.nodered.org/t/results-in-the-mysql-database-are-all-0-for-all-columns/86857/1 "2024-03-30T01:14:01Z")

</div>

why the results in the MySQL database are all 0 for all columns, can anyone tell me the correct code? The following flow and programming that I made

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/8/68bcf13f0ac188717eaa8cc9a2987b2c5508c34b.png)

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/8/78d582259a0bbee6780358edf707267b7edc9dca.png)

```auto
msg.topic = "INSERT INTO realtimealtprg01 (Speed, ProductName, TensionUW, TensionIF, TensionOf, TensionRW, UW, RW, ProductA, ProductB, ProductTotal ) VALUES ('', '','', '', '', '', '', '', '', '', '');"
return msg;

```

---

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