# Copying my Door control status back to my Mysql databse

**URL:** <https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383>\
**Category:** General\
**Created:** [20 July 2020 09:03 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383 "2020-07-20T09:03:04Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![dynamicdave](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dynamicdave/32/96_2.png) [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Post date:** [20 July 2020 10:26 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/21 "2020-07-20T10:26:25Z")

</div>

Then you need to do some reading/research, as @zenofmud suggested, about database design and construction and then try out some really SIMPLE examples.

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [20 July 2020 10:27 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/22 "2020-07-20T10:27:08Z")

</div>

Ok Sir.  
Thank You

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [20 July 2020 10:45 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/23 "2020-07-20T10:45:45Z")

</div>

![i](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/d/9da7064c3d51bb879a8d1c9c9f04c379e9318064.png)  
I have done it please check .

---

<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 July 2020 10:53 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/24 "2020-07-20T10:53:20Z")

</div>

and what is the sql statement you used to do the update?

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [20 July 2020 10:54 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/25 "2020-07-20T10:54:47Z")

</div>

UPDATE rfid1  
set Door\_Status='{{payload}}'  
WHERE name='Shipra Nigam';

---

<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 July 2020 10:55 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/26 "2020-07-20T10:55:57Z")

</div>

And what does the flow do if someone uses a different RFID?

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [20 July 2020 10:57 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/27 "2020-07-20T10:57:28Z")

</div>

that is where i am stucking ,i am searching and thinking how to do that,please help sir

---

<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 July 2020 11:03 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/28 "2020-07-20T11:03:00Z")

</div>

Once again I am going to suggest you stop trying to solve this until after you have taken the sql tutorial.

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [20 July 2020 11:44 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/29 "2020-07-20T11:44:13Z")

</div>

yes Sir i am reading

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [20 July 2020 11:53 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/30 "2020-07-20T11:53:08Z")

</div>

Sir one query i have ,I am entering my rfid no like E1234561 which is valid i want to give only control to that RFID fr updating the database .please suggest .Sorry for troubling

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [20 July 2020 12:11 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/31 "2020-07-20T12:11:00Z")

</div>

Sir Please anyone help

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [20 July 2020 12:23 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/32 "2020-07-20T12:23:55Z")

</div>

@Shipra this is not instant messaging, it is a forum where people reply to messages in their free time.

If someone doesn't reply instantly you do not need to to keep asking - it just means we're all a bit busy doing other things.

> [@shipra](#):
>
> I am entering my rfid no like E1234561 which is valid i want to give only control to that RFID fr updating the database .please suggest .Sorry for troubling

Please explain in much more detail. Please use words rather than screenshots to explain what you would like to achieve. Describe the whole scenario you are trying to create.

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [20 July 2020 12:28 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/33 "2020-07-20T12:28:31Z")

</div>

First of ol Sorry I will take care in future,  
Thank you Sir,  
I have 2 rfid in my database ,i have properly validate that with my database,  
Now,if one person (like rfid E1234561) enters the room and switch off their home door lights then i want to update only that (E1234561) rfid to be updated,  
i have tried but both RFID entries getting updated which is wrong

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [20 July 2020 12:29 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/34 "2020-07-20T12:29:49Z")

</div>

I am taking user input (rfid ) with a mqtt code now that flow i want to extend with this functionality

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [20 July 2020 12:30 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/35 "2020-07-20T12:30:55Z")

</div>

> [@shipra](#):
>
> i have tried but both RFID entries getting updated which is wrong

What SQL statement are you using to update the table?

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [20 July 2020 12:32 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/36 "2020-07-20T12:32:48Z")

</div>

UPDATE rfid1  
set Door\_Status='{{payload}}'  
WHERE rfidno='E1234561';  
which is giving me wrong ,for e.g if I am entering E1234562(USER2) in mqtt code,this user can update user 1 status i dont want this.

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [20 July 2020 12:36 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/37 "2020-07-20T12:36:32Z")

</div>

```auto
UPDATE rfid1
set Door_Status='{{payload}}'
WHERE rfidno='E1234561';

```

> [@shipra](#):
>
> which is giving me wrong ,for e.g if I am entering E1234562(USER2) in mqtt code,this user can update user 1 status i dont want this.

In your SQL you have hardcoded `E1234561` - so it will always update the row for that id.

If you want it to only update the row that corresponds to the id received, you need to build the query to include that id.

You are already inserting `msg.payload` into the query to dynamically set the status. Do you have the ID of the user as a message property that you can use here? Do you understand what I mean by that?

From what I recall of the previous thread, you start with the ID in `msg.payload` but it gets overwritten when you do the database lookup.

In which case, I suggest you add a Change node after the MQTT node, at the start of the flow, configured to set `msg.id` to the value of `msg.payload` - you will then be able to use `msg.id` later on in the flow.

As ever, use the Debug node to understand what properties your messages have.

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [20 July 2020 12:38 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/38 "2020-07-20T12:38:05Z")

</div>

> [@knolleary](#):
>
> Do you the ID of the user as a message property already that you can use here? Do you understand what I mean by

above this understood,but not this one ,Sorry sir please could you give me more hints

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [20 July 2020 12:38 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/39 "2020-07-20T12:38:48Z")

</div>

I have edited my previous reply to add some more detail.

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [20 July 2020 14:37 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/40 "2020-07-20T14:37:55Z")

</div>

I am struggling in this .I am not getting Sir

[Previous page](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383.md?page=1)

[Next page](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383.md?page=3)
