Thursday 25 January 2018

update table when male then female, when female then male



  update customer set Gender= Case WHEN gender='m' then 'f'
                                WHEN  gender='f' then 'm'
END 



No comments:

Post a Comment