insert all 求解
三火一木燊 2020-02-24 08:54:58 INSERT ALL
INTO table1 (ID,lOGIN_NAME,FULL_NAME,PASSWORD,IS_ACTIVE) VALUES('1','123TEST','123','12','Y')
INTO table2 (USER_ID,STATUS,WAVE_ID) VALUES((SELECT MAX(ID) FROM KASSIST.UQEC_USER WHERE lOGIN_NAME='123TEST'),'WERWE','538128')
SELECT 1 FROM DUAL;
這樣插入table2 的user_id取不到table1裏面的id,有什麽辦法在不同表插入的時候還能同時獲取到id查到另外一張表上,目前不考慮觸發器