You have described what you'd like to happen. Break that down in to a series of steps, like we did before. Then think about how to solve each step in turn. You should be able to make some progress based on what you've learnt so far. But to repeat, I am not building this for you.
No sir i dont want to repeat too, what i want is in my DB browser software i have to click that refresh symbol each time and then i am able to see the updated value can i change this by any method via node red,
Secondly i am designing a ui for this where user get the option to click the button and he can see this message" DB refreshed successfully" and for testing purpose i can check that in my DB side too .
@shipra, I have just realised that you have started discussing this on two threads.
Please do not discuss this further on this thread as it is nothing to do with the original question.
The other thread is How to refresh my sqlite 3 database through node red
Sir ,one query is there,as of now we dont have fire sensor in our project we are taking a pub node(FIRE topic) and if i got a string at that pub node a fire events generated and all the rfid scanning process should get stopped and "ALL door open" string should be inserted in my db. Could you please tell how can do this .