CREATE TRIGGER update_names
AFTER INSERT ON users
FOR EACH ROW
BEGIN
INSERT INTO names (name) VALUES (user.name) WHERE users.id=NEW.id;
END

CREATE TRIGGER update_names AFTER INSERT ON users
  FOR EACH ROW BEGIN
    INSERT INTO names SET name = NEW.name;
 END;

CREATE TRIGGER update_names AFTER  INSERT  ON users
FOR EACH
ROW 
INSERT  INTO  NAMES ( name ) VALUES (NEW.name);

DELIMITER |

CREATE TRIGGER testref BEFORE INSERT ON test1
  FOR EACH ROW BEGIN
    INSERT INTO test2 SET a2 = NEW.a1;
    DELETE FROM test3 WHERE a3 = NEW.a1;  
    UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
  END;
|
DELIMITER ;