
UPDATE T_PERM_PSWSTRATEGY set FMINLENGTH = 8,FISNUMBER = '1',FISLETTER = '1',FISSPECIAL = '1',FVALIDITY = 90,FFOREWARNDAY = 7,FLOCKCOUNT = 6,FLOCKTERM = 60,FREPEATTIMES = 3,FVERCODECTRL = 3 where FID = '338333884850648064' and EXISTS(SELECT fenable,count(*) from T_SEC_USER where fenable = '1' group by fenable HAVING count(*) < 10);
