insert into dm_mx(DMM,DM,MC,BZ1,BZ2,BZ3,BZ4,BZ5)
VALUES('JG0020','025','退休','','','','','1');

CREATE TABLE "GR_LJTXRYJC" (
"dwdm"  TEXT,
"dwmc"  TEXT,
"bzhm"  TEXT,
"xm"  TEXT,
"xb"  TEXT,
"csrq"  TEXT,
"grsf"  TEXT,
"blrq"  TEXT
);
update dm_mx set bz1 ='1' where dmm ='0210' and dm in ('030','033','040','043','050','051','053','060','061','063');
update dm_mx set mc = mc || '- 行号 ' || dm where mc in (select d.mc from dm_mx d where d.dmm = '0164' group by d.dmm, d.mc having count(1) >= 2);

 