MySQL Forums
Forum List  »  MySQL Workbench

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Values not saved after UPDATE
143
August 21, 2017 06:56PM
80
August 21, 2017 07:03PM
71
August 22, 2017 06:26AM


Sorry, only registered users may post in this forum.

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.