Hi,
Can anyone tell me if there are any differences in the syntax of Triggers or Stored Procedures in V9? We have recently upgraded to V9 and have a couple of triggers that I need to recreate. When I run the statement below I get a syntax error. This works fine in V8.x.
Any assistance would be appreciated. Cheers,
Russ.
Can anyone tell me if there are any differences in the syntax of Triggers or Stored Procedures in V9? We have recently upgraded to V9 and have a couple of triggers that I need to recreate. When I run the statement below I get a syntax error. This works fine in V8.x.
Any assistance would be appreciated. Cheers,
Russ.
Code:
CREATE TRIGGER ins_history
BEFORE INSERT ON history FOR EACH ROW
DECLARE
:v_last_history_id DOUBLE = 0;
BEGIN
-- Selects the last used HISTORY_ID
SELECT IFNULL(MAX(history_id),0)
INTO :v_last_history_id
FROM history;
-- Updates the new history_id with the last used id + 1
SET NEW.history_id = :v_last_history_id + 1;
-- Updates with String Version of Current Date
SET NEW.date = SUBSTRING(CONVERT(CURDATE(),SQL_CHAR),1,4) + SUBSTRING(CONVERT(CURDATE(),SQL_CHAR),6,2) + SUBSTRING(CONVERT(CURDATE(),SQL_CHAR),9,2);
-- Update Time
SET NEW.time = HOUR(CURTIME())*3600 + MINUTE(CURTIME())*60 + SECOND(CURTIME());
END;