CREATE?TRIGGER?TIGER_ID_NUM?BEFORE?INSERT?ON?USER_INFO?FOR?EACH?ROW?WHEN?(NEW.ID_NUM?IS?NULL) BEGIN? SELECT?SEQ_ID_NUM.nextval?INTO:?NEW.ID_NUM?FROM?dual; END?TIGER_ID_NUM?; /INSERT?INTO?user_info?VALUES?(null,?'admin',?'1',?'e10adc3949ba59abbe56e057f20f883e',?'超級管理員',?'0',?'20150709112043',?'20131008173414',?'20131218145707',?'lisy',?'20131218160814',?null,?null,?'B',?'B',?null,?null,?null,?null); INSERT?INTO?user_info?VALUES?(null,?'input1',?'1',?'e10adc3949ba59abbe56e057f20f883e',?'錄入員1',?'0',?'20140211152321',?'20131009163540',?'20131009164001',?'admin',?'20131224153836',?null,?null,?'B',?'B',?null,?'test3',?null,?null); INSERT?INTO?user_info?VALUES?(null,?'xxj',?'1',?'e10adc3949ba59abbe56e057f20f883e',?'李進',?'0',?'20150617164831',?'20150617160647',?'20150617163951',?'xxj',?'20150617163951',?null,?null,?'B',?null,?null,?'admin',?null,?null);