可以试试这样:将Sql = "update XXX set XXX=1 where XX in".然后在lists:foldl/3用户ID列表时,再将id拼凑到Sql中,这样,最后输出的结果是整一条sql语句,如:"update XXX set XXX=1 where XX in (1,2,3,4)"使用lists:concat([SqlAcc," (",N])、lists:concat([SqlAcc,",",N])、lists:concat([SqlAcc,",",N,")"]),应该是可行的....
|