Re: limit number of rows using a trigger

[Darren White]

nope. syntax problem. guess u cant use MIN like that?

Error Code: 1630. FUNCTION test.MIN does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual

ok that was just I had a space MIN () rather than MIN().

Now I am back to initial problem:

Error Code: 1442. Can't update table 'a_test' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.


-- Trigger DDL Statements
DELIMITER $$

USE `pgs`$$

CREATE
DEFINER=`root`@`localhost`
TRIGGER `test`.`log_limit`
AFTER INSERT ON `test`.`a_test`
FOR EACH ROW
BEGIN

SELECT MIN(last_update) INTO @min FROM a_test;
IF NEW.last_update - @min >= 30 THEN
DELETE FROM a_test ORDER BY last_update LIMIT 1;
END IF;
END$$



Edited 1 time(s). Last edit at 03/13/2012 04:19AM by Darren White.