@last_run_time是9.4。用户定义的变量和
last_run_timedatetime一个13.6.4.1。局部变量DECLARE语法是不同的变量。
尝试：
SELECt last_run_time;
更新
例：
DELIMITER $$CREATE PROCEDURE `sp_test`()BEGIN DECLARE current_procedure_name CHAr(60) DEFAULT 'accounts_general'; DECLARE last_run_time DATETIME DEFAULT NULL; DECLARE current_run_time DATETIME DEFAULT NOW(); -- Define the last run time SET last_run_time := (SELECT MAX(runtime) FROM dynamo.runtimes WHERe procedure_name = current_procedure_name); -- if there is no last run time found then use yesterday as starting point IF(last_run_time IS NULL) THEN SET last_run_time := DATE_SUB(NOW(), INTERVAL 1 DAY); END IF; SELECT last_run_time; -- Insert variables in table2 INSERT INTO table2 (col0, col1, col2) VALUES (current_procedure_name, last_run_time, current_run_time);END$$DELIMITER ;
