# 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:** 1
### Author:  [@shipra](https://discourse.nodered.org/u/shipra)
#### Post date: [20 July 2020 09:03 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/1 "2020-07-20T09:03:04Z")
I want to write and insert into a column (which is Door Status) ,it should be written as Door open /Door close back to mysql databse how to do that?Please help
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [20 July 2020 09:22 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/2 "2020-07-20T09:22:41Z")
So what have you tried so far?
What part are you having problems with?
Export your flow and paste it to a reply
---
### Author:  [@shipra](https://discourse.nodered.org/u/shipra)
#### Post date: [20 July 2020 09:26 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/3 "2020-07-20T09:26:12Z")
Sir I have one column name Door Status i am taking user input from a switch i want this updated data feed back to my database.
 
---
### Author:  [@shipra](https://discourse.nodered.org/u/shipra)
#### Post date: [20 July 2020 09:31 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/4 "2020-07-20T09:31:09Z")
@zenofmud please help Sir
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [20 July 2020 09:32 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/5 "2020-07-20T09:32:53Z")
I don't see anywhere you creating an sql update or attempting to do the update.
How are you going to identify which row in the database to update?
---
### Author:  [@shipra](https://discourse.nodered.org/u/shipra)
#### Post date: [20 July 2020 09:34 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/6 "2020-07-20T09:34:39Z")
I have created it through terminal in mysql
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [20 July 2020 09:40 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/7 "2020-07-20T09:40:00Z")
So where - in your flow - are you creating the sql update statement and where are you running that command?
---
### Author:  [@shipra](https://discourse.nodered.org/u/shipra)
#### Post date: [20 July 2020 09:41 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/8 "2020-07-20T09:41:45Z")
 
This is what i have done maybe its wrong ,please suggest
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [20 July 2020 09:51 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/9 "2020-07-20T09:51:43Z")
From what you have just added, I have to assume you do not have much experience with sql.
The statement will update every row in the database where `'Door_status = "NOT NULL"` and I don't think that is what you want to do.
Might I suggest you take a MySQL tutorial (such as this one: [https://www.w3schools.com/sql/](https://www.w3schools.com/sql/)) before you go any further.
---
### Author:  [@shipra](https://discourse.nodered.org/u/shipra)
#### Post date: [20 July 2020 09:53 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/10 "2020-07-20T09:53:39Z")
Yes Sir as i am new to mysql and node red I want to learn ,i will see the document right now but in case i dont get anything help me .thank you
---
### Author:  [@shipra](https://discourse.nodered.org/u/shipra)
#### Post date: [20 July 2020 09:54 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/11 "2020-07-20T09:54:51Z")
Now Sir check ones.
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [20 July 2020 09:57 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/12 "2020-07-20T09:57:26Z")
What do you think that statement will do?
You **really** need to take the SQL tutorial before trying to move forward.
---
### Author:  [@shipra](https://discourse.nodered.org/u/shipra)
#### Post date: [20 July 2020 09:58 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/13 "2020-07-20T09:58:27Z")
Ok Sir.I am studying that doc
---
### Author:  [@shipra](https://discourse.nodered.org/u/shipra)
#### Post date: [20 July 2020 10:01 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/14 "2020-07-20T10:01:24Z")
"Error: ER\_NO\_DEFAULT\_FOR\_FIELD: Field 'name' doesn't have a default value"
This Error is coming sir
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [20 July 2020 10:09 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/15 "2020-07-20T10:09:44Z")
If you want to use MySQL, you have to have some background in how to use it.
Stop trying to fix your flow until you have completed the tutorial! Then you will have a basic understanding of how to create an sql query to do what you want to do.
---
### Author:  [@shipra](https://discourse.nodered.org/u/shipra)
#### Post date: [20 July 2020 10:15 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/16 "2020-07-20T10:15:18Z")
Sir I am reading the Doc.
Thank You
---
### Author:  [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)
#### Post date: [20 July 2020 10:15 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/17 "2020-07-20T10:15:49Z")
I would also suggest you look at how you write a Date/Time (e.g. epoch value) to a database as I think you would want to record the time/date when the door was opened or closed.
---
### Author:  [@shipra](https://discourse.nodered.org/u/shipra)
#### Post date: [20 July 2020 10:17 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/18 "2020-07-20T10:17:27Z")
Hello @dynamicdave SIr. Actually Sir i want to record my incoming data/update data for e.g(Door open) into my Door Status column in my DB
---
### Author:  [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)
#### Post date: [20 July 2020 10:22 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/19 "2020-07-20T10:22:10Z")
Well, if it was my project, I would have two columns.
One labelled status and one labelled epoch or time.
If you are unfamiliar with what 'epoch' is you could have a three column layout like this...
'status' 'date' 'time'
To keep it simple, all the columns could be defined as text.
In the 'status' column you could store the text string 'open' or 'close'.
---
### Author:  [@shipra](https://discourse.nodered.org/u/shipra)
#### Post date: [20 July 2020 10:23 UTC](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383/20 "2020-07-20T10:23:43Z")
Yes Sir i want to know how to write/insert open/close back into column name
[Next page](https://discourse.nodered.org/t/copying-my-door-control-status-back-to-my-mysql-databse/30383.md?page=2)