SQLog statement-CodePudding

The UPDATE ` cos02bo - a `. ` currency value ` ` SET `='1.00000000' WHERE ` code `='$';
The UPDATE ` cos02bo - a `. ` currency value ` ` SET `='0.93000000' WHERE ` code `='EUR';
The UPDATE ` cos02bo - a `. ` currency value ` ` SET `='0.82000000' WHERE ` code `='GBP';

How the three statements written in a

CodePudding user response:

 UPDATE ` cos02bo - a `. ` currency ` 
The SET value ` `=CASE WHEN ` code `='$' THEN' 1.00000000 '
The WHEN ` code `='EUR' THEN '0.93000000' 
The WHEN ` code `='GBP' THEN '0.82000000' 
END 
WHERE ` code ` IN (' $', 'was',' GBP);