|
SQL Manager 2007 for MySQL 4.1.2.1的数据库如何改为5.0可以适用的?部分代码:
# SQL Manager 2007 for MySQL 4.1.2.1
# ---------------------------------------
# Host : localhost
# Port : 3336
# Database : shop
#
# Definition for the `CheckTimeGreater` function :
#
DROP FUNCTION IF EXISTS `CheckTimeGreater`;
CREATE FUNCTION `CheckTimeGreater`(
starthour VARCHAR(10),
startmin VARCHAR(10),
starsec VARCHAR(10),
endhour VARCHAR(10),
endmin VARCHAR(10),
endsec VARCHAR(10)
)
RETURNS int(4)
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
declare r_flag INT(4);
if starthour>endhour or starthour<endhour then
if starthour>endhour then
set r_flag = 0;
elseif starthour<endhour then
set r_flag = 1;
end if;
else
if startmin>endmin or startmin<endmin then
if startmin>endmin then
set r_flag = 0;
elseif startmin<endmin then
set r_flag = 1; |
|