-1

I want to update my table and set a financial period to a year from a given column [Declearation period]

set [YEAR]='2019' where [DECLEARATION_PERIOD] ='01-MAR-19','01-APR-19','01-MAY-19','01-JUN-19','01-JUL-19','01-AUG-19','01-SEP-19' ,'01-OCT-19','01-NOV-19','01-DEC-19','01-JAN-20','01-FEB-20'

New contributor
C'mphiwe Donald is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
Related questions
2773
How can I prevent SQL injection in PHP?
2768
How to import an SQL file using the command line in MySQL?
0
MySQL Order by month in specific order
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.