在tab_user_detail表增加一條數據後,往tab_user表增加一條記錄
create trigger tri_user_insert
after insert on tab_user_detail
for each row
begin
insert into tab_user (USER_ID,USER_NAME,USER_PWD,USER_CUSTOMERNAME,USER_PHOTOS) values (:new.MY_USERID,'username','password','truename','Default.jpg');
end;