SELECT ID,LOGIN,LAST_ACTIVITY_DATE from b_user; USE sitemanager; UPDATE b_user_password SET DATE_CHANGE = NOW() WHERE ID = ( SELECT MAX(ID) FROM b_user_password WHERE USER_ID = 1 );
SELECT ID,LOGIN,LAST_ACTIVITY_DATE from b_user; USE sitemanager; UPDATE b_user_password SET DATE_CHANGE = NOW() WHERE ID = ( SELECT MAX(ID) FROM b_user_password WHERE USER_ID = 1 );