CREATE TABLE `probnafifo` (
  `idprobnaFIFO` int(11) NOT NULL AUTO_INCREMENT,
  `tekst` varchar(45) DEFAULT NULL,
  `Vrijeme` datetime DEFAULT NULL,
  PRIMARY KEY (`idprobnaFIFO`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8

CREATE DEFINER=`usysa`@`%` TRIGGER insertFIFO after insert
ON usys.probnafifo
FOR EACH ROW
BEGIN
DECLARE rowcount, indeks int default 0;
SELECT COUNT(*) INTO rowcount FROM usys.probnafifo;
select idprobnaFIFO into @indeks from usys.probnafifo order by Vrijeme limit 1;
   IF rowcount > 10 THEN
delete from usys.probnafifo where idprobnafifo = indeks;
end if;
END