Re: xpost from triggers: create before insert, mysqlworkbench: the object's DDL contains syntax error

[Peter Brawley]

Is this what you mean?

set new.person_join_date = 
  select birth_date 
  from people 
  where people_id=new.people_people_id;