我在Mysql中创建Sp时遇到错误请帮助!!注意：仅在我添加条款或其他条款时才会出现错误 [英] I Am Getting Error In Creating Sp In Mysql Please Help!! Note: Getting Error Only When I Am Adding Where Clause Or Else Its Working Fine

问题描述

create procedure StudentTimeLineByUserCode( _userCode varchar(20), _startDate datetime, _endDate datetime)
 
Begin

SET @strTblQuery = concat("select * from ", _userCode, "_", "Timeline" where dateCreated>=_startDate AND dateCreated<=_endDate);

    SELECT @strTblQuery;

        PREPARE stmt1 FROM @strTblQuery;
        EXECUTE stmt1;
        DEALLOCATE PREPARE stmt1;

 end

推荐答案

此行有错误的报价对...

This line has wrong quote-pairs...

SET @strTblQuery = concat("select * from ", _userCode, "_", "Timeline" where dateCreated>=_startDate AND dateCreated<=_endDate);

试试这个...

Try this...

SET @strTblQuery = concat("select * from ", _userCode, "_Timeline where dateCreated>='",_startDate, "' AND dateCreated<='",_endDate,"'");

这篇关于我在Mysql中创建Sp时遇到错误请帮助!!注意：仅在我添加条款或其他条款时才会出现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！