Set the capacity in a mysql table so it can hold 150 rows?

Question

I'm using phpMyAdmin and I want to set the capacity of a table so it can only store 150 rows. Is this possible? My table is InnoDB.

Answer 1

This is not possible without using a trigger.

Answer taken from here.

DELIMITER $$

CREATE TRIGGER trigger1
BEFORE INSERT
ON table1
FOR EACH ROW
BEGIN
  SELECT COUNT(*) INTO @cnt FROM table1;
  IF @cnt > 150 THEN
    CALL sth(); -- raise an error
  END IF;
END
$$

DELIMITER ;