php - mysql update values in foreign key field value with parent key -

in database there table name session , session_id primary key of that. , there member table , member_id primary key. there relationship between 2 tables. session_id foreign key of member table. want update member_id same value of session_id while insert value session table. can me this??

you can use mysql trigger accomplish this:

create trigger update_trigger after insert on session each row begin     update member     set member_id = new.session_id end;