将数组传递到存储过程中

所以我找到了一个解决方法,将查询和参数连接起来,这样就可以生成伪代码

CREATE PROCEDURE `related_stories`(IN param1 VARCHAR(255), IN param2 VARCHAR(255), IN param3 VARCHAR(255), IN publishDate INT(11), IN tlimit INT(11))
BEGIN

SET  @query =CONCAT( '

select s.* from 
(

select * from 
(
 SELECT something where condition IN (',param1,')
) as table1

UNION ALL

select * from 
(
 SELECT something where condition IN (',param2,')
) as table2

UNION ALL

select * from 
(
 SELECT something where condition IN (',param3,')
) as table3

) as s

WHERE (s.publish_date < ',publishDate,') 
GROUP BY id limit ',tlimit,';');

PREPARE stmtInsert FROM @query;
EXECUTE stmtInsert;

END

param1、param2、param3是通过php传入的内爆数组,例如('1,2,3,4')。希望这对别人有帮助

我认为这里的主要问题是MySQL不支持数组作为数据类型。你需要组成一个团队 one-to-many