请赐教： SQL Manager 2007 for MySQL 4.1.2.1的数据库如何改为5.0可以适用的

cztc1 · 发表于 2010-9-2 14:55:38

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;