Values not saved after UPDATE
Posted by:
Paul Hives
Date: August 21, 2017 06:56PM
I am using the following statement:
UPDATE WEBFSS.MEMBER_PROFILE SET FUNDING = CASE
WHEN FUNDING = 'ARRA' THEN 1
WHEN FUNDING = 'Care Trans' THEN 2
WHEN FUNDING = 'CCSP' THEN 3
WHEN FUNDING = 'FS' THEN 4
WHEN FUNDING = 'ITC' THEN 5
WHEN FUNDING = 'NSIP Trans' THEN 6
WHEN FUNDING = 'NSIP SSBG sup' THEN 7
WHEN FUNDING = 'NSIP State' THEN 8
WHEN FUNDING = 'Private Pay' THEN 9
WHEN FUNDING = 'T-3' THEN 10
WHEN FUNDING = 'UA' THEN 11
WHEN FUNDING = 'UW' THEN 12
END
When I look at the table it all appears to have updated. However, after closing and re-opening Workbench all the update values have reverted to original values.
Still new to MySQL but I have never experienced this in other SQL databases.
Subject
Views
Written By
Posted
Values not saved after UPDATE
577
August 21, 2017 06:56PM
371
August 21, 2017 07:03PM
264
August 22, 2017 06:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.