Re: limit number of rows using a trigger

[Darren White]

Well this was applied ok but now another error:
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`
BEFORE INSERT ON `test`.`a_test`
FOR EACH ROW
BEGIN

SELECT COUNT(*) INTO @cnt FROM a_test;

IF @cnt >= 5 THEN
DELETE FROM a_test ORDER BY last_update LIMIT 1;
END IF;

END$$



Edited 2 time(s). Last edit at 03/13/2012 03:58AM by Darren White.