title: MySQL TRIGGER BEFORE INSERT
body: <p>I cant get this to work, it runs OK, but nothing happens in insert</p>
  
  <pre><code>DROP TRIGGER IF EXISTS test;
  DELIMITER $$
  CREATE
      TRIGGER test BEFORE INSERT 
      ON prueba 
      FOR EACH ROW     
      BEGIN
          SET NEW.jo=1
      END
  DELIMITER $$;
  insert into prueba (ja) values (16);
  
  CREATE TABLE `prueba` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `ja` int(11) DEFAULT NULL,
    `jo` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `prueba` WRITE;
  </code></pre>
  
  <p>What im i doing wrong??</p>