关于mysql5.1存储过程问题

0 0

关于mysql5.1存储过程问题5

以下是mysql5.1的存储过程，主要功能流程是这样的：
现在有表cmts_cap_port_temp,存储过程先要把cmts_cap_port_temp表重命名为cmts_cap_port_temp+日期，然后再重新
创建新的cmts_cap_port_temp表。

create procedure p_capTableHandle()
begin
   declare @v_count int;
   declare @t_capName varchar(50);
   declare @sqlstr varchar(1000);
/**创建性能临时表结构**/
set @sqlstr= concat('create table `cmts_cap_port_temp`','(
`Id` bigint(11) NOT NULL auto_increment,
`RouteId` int(11) default NULL,
`PortId` bigint(20) default NULL,
`PortName` varchar(100) default NULL,
`PortTotalUser` int(11) default NULL,
`PortOfflineUser` int(11) default NULL,
`PortUnRegisterUser` int(11) default NULL,
`PortOnlineUser` int(11) default NULL,
`PortFEC` bigint(20) default NULL,
`PortSNR` int(11) default NULL,
`PortDownPower` int(11) default NULL,
`PortUpPower` int(11) default NULL,
`PortOutFlux` bigint(11) default NULL,
`PortInputFlux` bigint(11) default NULL,
`PortSpeed` bigint(11) default NULL,
`RecordTime` datetime default NULL,
PRIMARY KEY (`Id`),
KEY `FK_Reference_tempPort_RoutInfo` (`RouteId`),
KEY `FK_Reference_tempPort_LogicPort` (`PortId`),
CONSTRAINT `cmts_cap_port_temp_ibfk_1` FOREIGN KEY (`PortId`) REFERENCES `net_resportinfo` (`PortId`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_Reference_tempPort_RoutInfo` FOREIGN KEY (`RouteId`) REFERENCES `net_routinfo` (`RoutId`) ON DELETE CASCADE ON UPDATE CASCADE
)');
/**--end--**/
   select concat('cmts_cap_port_temp',date_format(adddate(now(),-1),'%Y%m%d')) into @t_capName;
   select count(*) into @v_count from cmts_cap_port_temp;

   if(@v_count>0) then
      rename table cmts_cap_port_temp to city t_capName;
     commit;

PREPARE DD FROM @sqlstr;
EXECUTE DD;

end if;
end
现出现下面的错误，不能创建该存储过程，请问是哪里出了问题呢？
ERROR 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 '@v_count int;
   declare @t_capName varchar(50);
   declare @sqlstr varchar(10' at line 3