UPDATE tablefortest SET testbit = CASE WHEN TEST_YN = 'Y' THEN '1' ELSE '0' END;UPDATE tablefortestSET testbit = IF(TEST_YN LIKE 'Y', '1', '0');
这两个查询都需要0.8秒~1.1秒。
我只是发现了Nimrod并且有一个基本的问题(在文档中找不到答案)。if x and 1:Error: type mismatch: got (range 0..1(int)) but expected 'bool'if and(x, 1)Error: type mismatch: got (tuple[int, int])system.and(x: int16, y: int16): int16
system.and(x: i