56,678
社区成员
发帖
与我相关
我的任务
分享
DELIMITER $$
/*!50003 CREATE DEFINER=`JYC_IT2388`@`192.168.1.%` PROCEDURE `CalculateWeightProduct`(
/*
1、统计产品并计算产品的权重
2、将产品及权重更新至产品权重表
*/
IN _beginTime DATETIME
,IN _endTime DATETIME
)
BEGIN
SELECT *
FROM(
SELECT jg.gid, jg.gname, jg.glogo, jgp.packsize, jgp.downloadurl
,jg.score+jg.scoreplus score, jgp.packname
FROM JYC_IT2388.jyc_game jg
JOIN JYC_IT2388.jyc_gamepack jgp ON jgp.gid=jg.gid
WHERE 1=1
ORDER BY jg.createtime DESC
)a
LIMIT _beginIndex, _pageSize;
错误如下:
错误码: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '_beginIndex, _pageSize;