create procedure proc_batchUpdate(in categoryId integer , in artIds varchar(50))
   begin
    set @dsql = count('update article set type=' , categoryId , ' where id  in (' , artIds , ')') ;   
    prepare s1 from @dsql;
    execute s1;
  end;