Error code: 1247 Reference 'starttime' not supported (forward reference in item list), 1247 startTime
1. Error description
1 queries executed, 0 success, 1 errors, 0 warnings query: SELECT. createUserId AS typeId, (select count (c. id) FROM t_aps c WHERE c. 'status' IN (2, 5) AND c. createTime> = start... error code: 1247 Reference 'starttime' not supported (forward reference in item list) execution time: 0 sec Transfer Time: 0 sec total time: 0 sec
2. Error cause
Because in the stored procedure, when passing parameters:
C. createTime> = startTime and c. createTime <= endTime
To check whether the query statement is correct, I directly run the query statement with parameters in the stored procedure on the client, resulting in an error.
3. Solution
(1) comment out the statement segments with Parameters
(2) Replace the parameter with a specific value.
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.