# Can not send data to table MariaDB, please help

**URL:** https://discourse.nodered.org/t/can-not-send-data-to-table-mariadb-please-help/31324
**Category:** General
**Created:** [8 August 2020 20:20 UTC](https://discourse.nodered.org/t/can-not-send-data-to-table-mariadb-please-help/31324 "2020-08-08T20:20:03Z")
**Posts on this page:** 4
**Page:** 2

<div class="post-metadata">

### Author: ![WesleyFranken](https://avatars.discourse-cdn.com/v4/letter/w/51bf81/32.png) [@WesleyFranken](https://discourse.nodered.org/u/WesleyFranken)
#### Post date: [9 August 2020 15:40 UTC](https://discourse.nodered.org/t/can-not-send-data-to-table-mariadb-please-help/31324/21 "2020-08-09T15:40:43Z")

</div>

I try to deliver the timestap in a way that the MariaDB accepts.

I can simulate an inject with the app HeidiSQL and this is what I got back:

**INSERT**  **INTO** `digitalempire`.`meterdata` (`client`, `project`, `meter_id`, `date`, `value`) **VALUES** ('client7', 'project7', 'meter\_id7', '2020-08-09 17:37:37', '7');

So this is the reason I om chopping the timestamp into bits and pieces and then shuffle them in a way that works.

I hope I make sense 🙂

---

<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: [9 August 2020 15:45 UTC](https://discourse.nodered.org/t/can-not-send-data-to-table-mariadb-please-help/31324/22 "2020-08-09T15:45:05Z")

</div>

Are you trying to write the current time? If so then use a Timestamp column and tell it to automatically insert the current time for you, `DEFAULT CURRENT_TIMESTAMP`. Then you don't have to do anything.

---

<div class="post-metadata">

### Author: ![WesleyFranken](https://avatars.discourse-cdn.com/v4/letter/w/51bf81/32.png) [@WesleyFranken](https://discourse.nodered.org/u/WesleyFranken)
#### Post date: [9 August 2020 15:55 UTC](https://discourse.nodered.org/t/can-not-send-data-to-table-mariadb-please-help/31324/23 "2020-08-09T15:55:42Z")

</div>

Thank you all very much!

My issues are completely resolved.

---

<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: [23 August 2020 15:55 UTC](https://discourse.nodered.org/t/can-not-send-data-to-table-mariadb-please-help/31324/24 "2020-08-23T15:55:49Z")

</div>

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

[Previous page](https://discourse.nodered.org/t/can-not-send-data-to-table-mariadb-please-help/31324.md?page=1)