title: MYSQL multiple event in a trigger
body: <p>How can I create a trigger for this two CHECK constraint</p>
  
  <pre><code>create table section ( course_id varchar(8), 
      sec_id varchar(8), 
      semester varchar(6) 
      check (semester in ('Fall', 'Winter', 'Spring', 'Summer')), 
      year numeric(4,0) 
      check (year &gt; 1701 and year &lt; 2100), 
      building varchar(15), 
      room_number varchar(7), 
      time_slot_id varchar(4), 
      primary key (course_id, sec_id, semester, year), 
      foreign key (course_id) references course on delete cascade, 
      foreign key (building, room_number) references classroom on delete set null);
  </code></pre>
  
  <p>========================================================================</p>
  
  <p>Except for a solution.</p>