刚用mySQL,运行不了,请问是什么问题,谢谢DELIMITER $$DROP PROCEDURE IF EXISTS `infwebbi_v105x_gm`.`SP_Sales_Report_By_Hour`$$CREATE DEFINER=`root`@`localhost` PROCEDURE `SP_xxx`(Begin_Date date, End_Date date,OutLet varchar(50) )
BEGIN
CREATE TEMPORARY TABLE tmp_time (
FID INTEGER NOT NULL,
FSTART VARCHAR(10) NOT NULL,
FEND varchar(10)
); DECLARE iHour INT; SET @iHour=0; WHILE (iHour<24)
INSERT INTO tmp_time(FID,FSTART,FEND) Values(iHour,LPAD(trim(cast(iHour As CHAR)),2,'0'),':00',LPAD(trim(cast(iHour As CHAR)),2,'0'),':59');
END WHILE
select * from tmp_time;
END$$DELIMITER ;
BEGIN
CREATE TEMPORARY TABLE tmp_time (
FID INTEGER NOT NULL,
FSTART VARCHAR(10) NOT NULL,
FEND varchar(10)
); DECLARE iHour INT; SET @iHour=0; WHILE (iHour<24)
INSERT INTO tmp_time(FID,FSTART,FEND) Values(iHour,LPAD(trim(cast(iHour As CHAR)),2,'0'),':00',LPAD(trim(cast(iHour As CHAR)),2,'0'),':59');
END WHILE
select * from tmp_time;
END$$DELIMITER ;
解决方案 »
- MySQL那个版本好,并且最好用!
- 求SQL语句。谢谢 在线等。
- 我用PostgreSQL数据库,执行一个insert错误后,2个半小时的时间内,不能再对这个表进行insert操作。2个半小时以后,insert的其他语句才能执行。为什么?
- mysql占用资源,怎么查有问题的mysql用户
- 简单问题,如何限制select结果的个数?
- update替换语句如何写?
- 如何使用SQL语句备份整个数据库?
- 这个应该怎么查,高手帮看看
- InnoDB查询数据的问题
- MySQLIntegrityConstraintViolationException: Duplicate entry for key 'PRIMARY' 错误
- 请问一句 mysql语句
- MySql 怎样修改某字段的属性?使其不自动增长??
BEGIN
CREATE TEMPORARY TABLE tmp_time (
FID INTEGER NOT NULL,
FSTART VARCHAR(10) NOT NULL,
FEND varchar(10)
); DECLARE iHour INT; SET iHour=0; WHILE (iHour <24)
INSERT INTO tmp_time(FID,FSTART,FEND) Values(iHour,LPAD(trim(cast(iHour As CHAR)),2,'0'),':00',LPAD(trim(cast(iHour As CHAR)),2,'0'),':59');
END WHILE
select * from tmp_time;
END$$ DELIMITER ;SQLyog运行时,提示
(0 row(s)affected)
(0 ms taken)Error Code : 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 'DECLARE iHour INT; SET iHour=0; WHILE (iHour<24)
INSERT INTO tmp_time' at line 9
(0 ms taken)Error Code : 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 'END$$DELIMITER' at line 25
(0 ms taken)Error Code : 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 'END$$
DELIMITER' at line 25
(0 ms taken)
INSERT INTO tmp_time(FID,FSTART,FEND) Values(iHour,LPAD(trim(cast(iHour As CHAR)),2,'0'),':00',LPAD(trim(cast(iHour As CHAR)),2,'0'),':59');
参数并不匹配。错得地方比较多。
DELIMITER $$DROP PROCEDURE IF EXISTS `SP_xxx`$$CREATE PROCEDURE `SP_xxx`(Begin_Date date, End_Date date,OutLet varchar(50) )
BEGIN
DECLARE iHour INT;
CREATE TEMPORARY TABLE tmp_time (
FID INTEGER NOT NULL,
FSTART VARCHAR(10) NOT NULL,
FEND varchar(10)
);
SET iHour=0;
WHILE (iHour <24) DO
INSERT INTO tmp_time(FID,FSTART,FEND) Values(
iHour,
right(concat('00',iHour,':00'),5),
right(concat('00',iHour,':59'),5));
END WHILE;
select * from tmp_time;
END$$DELIMITER ;