摘要:
delimiter $$ CREATE PROCEDURE getDeviceRow7( IN deviceType VARCHAR(50), IN page INT(10), IN size INT(10) , IN deviceValue VARCHAR(50) ) BEGIN -- 1.定义一 阅读全文
摘要:
SELECT a.project_id AS projectid ,a.eva_ass_id AS assid , b.pr_name AS projectname , c.name as assname ,COUNT(if(score ='5',a.project_id,null)) AS toc 阅读全文