Post
Ask Question
yesubabu k

yesubabu k

  • 1.1k
  • 644
  • 63.6k

update status if any row changes in table

Mar 8 2019 4:47 AM
Dear Experts,
 
I have a table , it has  Date and Stutus fields
 
Date                 Status
====                ====== 
2019-03-01          0
2019-03-02          0
2019-03-03          0
2019-03-04          0
2019-03-05          0
2019-03-06          0
2019-03-07          0
 
like this 
 
when i change date through application status will be immediatly change status=1
 
how to write a query  in sql

Answers (3)