Trigger won't insert row
<p>I have a trigger:</p>

<pre><code>CREATE DEFINER=`root`@`100.100.100.100` TRIGGER `MYSCHEMA`.`MY_TABLE_BEFORE_INSERT` BEFORE INSERT ON `my_table` FOR EACH ROW
BEGIN

IF NEW.id = 5 AND NEW.field_name = 'my_field' THEN
    INSERT INTO my_table(id, field_name, value) VALUES (9999, 'something','test');
END IF;

END
</code></pre>

<p>When I run the code from my front end it simply doesn't no insert the new row. ID and field_name together are always unique so this insert statement will not run more than once.</p>