yesubabu k

yesubabu k

  • 1k
  • 621
  • 57.4k

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)