voiciXs notes

#drop trigger
DROP TRIGGER `TRIGGER_NAME`
 
#auto DateTime, Date, Time
CREATE TRIGGER `TRIGGER_NAME` BEFORE INSERT ON `TABLE_NAME`
 FOR EACH ROW SET NEW.DATEFIELD = NOW()
 
#insert something in another table
CREATE TRIGGER `TRIGGER_NAME` AFTER INSERT ON `TABLE_NAME`
 FOR EACH ROW
  INSERT INTO another_table SET some_field = NEW.fieldfromparenttable, text_field = 'sometext'
 
#if statement
CREATE TRIGGER `TRIGGER_NAME` AFTER INSERT ON `TABLE_NAME`
 FOR EACH ROW BEGIN
  IF NEW.Type = 0 THEN
    INSERT INTO another_table SET ParentType = NEW.Type;
  END IF;
 END