从mysql迁移过来的一条sql。里面包含case when then。如下:
SELECT y.id AS "id",
CASE
WHEN y.safe_strategy = '0' THEN "按表"
WHEN y.safe_strategy = '1' THEN "按列"
WHEN y.safe_strategy = '2' THEN "按行" END AS "safeStrategy",
y.security_rule_id AS "securityRuleId"
FROM data_manu_classify y
请问这么能兼容一下呢
按表,按列,按行的双引号改为单引号即可执行。
SELECT y.id AS "id",
CASE
WHEN y.safe_strategy = '0' THEN '按表'
WHEN y.safe_strategy = '1' THEN '按列'
WHEN y.safe_strategy = '2' THEN '按行' END AS "safeStrategy",
y.security_rule_id AS "securityRuleId"
FROM data_manu_classify y