tomato

update PERSON set sex=( case when sex='a' then 'b' when sex='b' then 'a' end)

1. A为库名,B为表名create sequence A.SEQ_B minvalue 1maxvalue 99999999999999999999start with 1increment by 1cache 20; 2. 字段解读createsequenceA.SEQ_B //SEQ_后边为表名minvalue1 //最小值maxvalue9999999999999999999 //生成的最大值startwith1 //序列的初始值，默认为1i...