mysql预处理解决方法

mysql预处理

SQL code

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;