mysqlÔ¤´¦Àí - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

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;



ÎÒÖ´ÐÐÕâ¸ö±¨´í£¬ÒªÔõô¸Ä°¡£¿

---

¼ì²éһϠ@dsql; µÄÄÚÈÝÊÇʲô¡£ ¹À¼ÆÄãµÄÕâ¸ö¶¯Ì¬µÄSQLÓï¾äÓï·¨´íÎó¡£

---

ÿÌì»ØÌû¼´¿É»ñµÃ10·Ö¿ÉÓ÷֣¡

---

ÒýÓÃ

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 , ')') ;¡­¡­

ÕâÀï±ßµÄcountÊÇʲôÒâ˼£¿ ²»ÊÇconcatÖ®ÀàµÄÂð£¿