# Delete and update operation using mysql in bootstrap table

**URL:** https://discourse.nodered.org/t/delete-and-update-operation-using-mysql-in-bootstrap-table/38507
**Category:** Dashboard
**Created:** [4 January 2021 10:48 UTC](https://discourse.nodered.org/t/delete-and-update-operation-using-mysql-in-bootstrap-table/38507 "2021-01-04T10:48:26Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![sanket](https://avatars.discourse-cdn.com/v4/letter/s/57b2e6/32.png) [@sanket](https://discourse.nodered.org/u/sanket)
#### Post date: [4 January 2021 10:48 UTC](https://discourse.nodered.org/t/delete-and-update-operation-using-mysql-in-bootstrap-table/38507/1 "2021-01-04T10:48:27Z")

</div>

I want to perform delete and update operation using mysql database in bootstrap table form.

---

<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: [4 January 2021 11:20 UTC](https://discourse.nodered.org/t/delete-and-update-operation-using-mysql-in-bootstrap-table/38507/2 "2021-01-04T11:20:50Z")

</div>

So what have you tried? Where are you having a problem?

---

<div class="post-metadata">

### Author: ![sanket](https://avatars.discourse-cdn.com/v4/letter/s/57b2e6/32.png) [@sanket](https://discourse.nodered.org/u/sanket)
#### Post date: [5 January 2021 08:04 UTC](https://discourse.nodered.org/t/delete-and-update-operation-using-mysql-in-bootstrap-table/38507/3 "2021-01-05T08:04:23Z")

</div>

I dont know how do it. I can share my json file with you.

---

<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: [5 January 2021 12:07 UTC](https://discourse.nodered.org/t/delete-and-update-operation-using-mysql-in-bootstrap-table/38507/4 "2021-01-05T12:07:33Z")

</div>

> [@sanket](#):
>
> I can share my json file with you.

That would be a good idea along with

- the version of NR and node.js (see the start up log)
- the version of the mysql node (go to the palette manager to find this)

When asking for help, it is a good idea to give as much detail as you can. Remember, you know your setup and what you want to do, but no one else does. So you need to elaborate on what you mean by wanting to update and delete in bootstrap table form.

---

<div class="post-metadata">

### Author: ![sanket](https://avatars.discourse-cdn.com/v4/letter/s/57b2e6/32.png) [@sanket](https://discourse.nodered.org/u/sanket)
#### Post date: [20 January 2021 11:25 UTC](https://discourse.nodered.org/t/delete-and-update-operation-using-mysql-in-bootstrap-table/38507/5 "2021-01-20T11:25:25Z")

</div>

[flows (23).json](https://discourse.nodered.org/uploads/short-url/hj9wFqvEfv1RE9xtbZkfRkkwvtW.json) (96.7 KB)

---

<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: [20 January 2021 11:30 UTC](https://discourse.nodered.org/t/delete-and-update-operation-using-mysql-in-bootstrap-table/38507/6 "2021-01-20T11:30:52Z")

</div>

> [@zenofmud](#):
>
> That would be a good idea `along with`
> 
> - the version of NR and node.js (see the start up log)
> - the version of the mysql node (go to the palette manager to find this)

Also paste your flow into a response (see this thread: [How to share code or flow json](https://discourse.nodered.org/t/how-to-share-code-or-flow-json/506))

Also what is the DB schema?

---

<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: [19 February 2021 11:30 UTC](https://discourse.nodered.org/t/delete-and-update-operation-using-mysql-in-bootstrap-table/38507/7 "2021-02-19T11:30:58Z")

</div>

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