DELIMITER $$
CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global
FOR EACH ROW BEGIN
IF STRCMP(NEW.Variable_name,'ASN') != 0 THEN
set NEW.Variable_name=NULL;
ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN
set NEW.Variable_name=NULL (<<-- Missing Semicolon)
ELSEIF STRCMP(NEW.Variable_name, 'ASN') != 0 THEN (<<-- Same as IF)
set NEW.Value=CONVERT(CONVERT(NEW.Value, UNSIGNED), CHAR);
ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN (<<-- Same as First
ELSEIF)
set NEW.Value=INET_NTOA(INET_ATON(NEW.Value));
ENDIF (<<-- Missing Semicolon)
END;
DELIMITER ;
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-660-3221 (Cell)
AIM & Skype : RolandoLogicWorx
[email protected]
-----Original Message-----
From: Rolando Edwards [mailto:[email protected]]
Sent: Tuesday, May 19, 2009 12:40 PM
To: Alex Katebi; [email protected]
Subject: RE: What is wrong with this SYNTAX?
DELIMITER $$
CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global
FOR EACH ROW BEGIN
IF STRCMP(NEW.Variable_name,'ASN') != 0 THEN
set NEW.Variable_name=NULL;
ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN
set NEW.Variable_name=NULL (<<-- Missing Semicolon)
ELSEIF STRCMP(NEW.Variable_name, 'ASN') != 0 THEN (<<-- Same as IF)
set NEW.Value=CONVERT(CONVERT(NEW.Value, UNSIGNED), CHAR);
ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN (<<-- Same as First
ELSEIF)
set NEW.Value=INET_NTOA(INET_ATON(NEW.Value));
ENDIF
END;
DELIMITER ;
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-660-3221 (Cell)
AIM : RolandoLogicWorx
Skype : RolandoLogicWorx
[email protected]
-----Original Message-----
From: Alex Katebi [mailto:[email protected]]
Sent: Tuesday, May 19, 2009 10:33 AM
To: [email protected]
Subject: What is wrong with this SYNTAX?
It is complaining about near STRCMP.
CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global
FOR EACH ROW BEGIN
IF STRCMP(NEW.Variable_name,'ASN') != 0 THEN
set NEW.Variable_name=NULL;
ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN
set NEW.Variable_name=NULL
ELSEIF STRCMP(NEW.Variable_name, 'ASN') != 0 THEN
set NEW.Value=CONVERT(CONVERT(NEW.Value, UNSIGNED), CHAR);
ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN
set NEW.Value=INET_NTOA(INET_ATON(NEW.Value));
ENDIF
END
Thanks in advance!
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
