我最终通过添加一个函数（如果有人想）来做到这一点......

I eventually did it by adding a Function (if anyone would like to)...

<pre lang="sql">DELIMITER

DROP FUNCTION IF EXISTS`videostreamer``countReported`

DROP FUNCTION IF EXISTS `videostreamer`.`countReported`

CREATE FUNCTION`videostreamer``cou ntReported`（aembed_ID int）RETURNS INTEGER
BEGIN

DECLARE Temp INTEGER;
SELECT count（id）INTO Temp FROM报告其中embed_id = aembed_ID;
RETURN IFNULL（临时，0）;

END

CREATE FUNCTION `videostreamer`.`countReported` (aembed_ID int) RETURNS INTEGER BEGIN DECLARE Temp INTEGER; SELECT count(id) INTO Temp FROM reported where embed_id = aembed_ID; RETURN IFNULL(Temp, 0); END