-- 해당 조건 유저중 개인계좌 데이터 없는 유저확인
/*SELECT member.idx, personal_account_number.member_idx
FROM member
left join personal_account_number on member.idx = personal_account_number.member_idx
where member.u_business = 1 and level = 2*/

-- 조건에 맞는 유저보기
/*SELECT * FROM mydb_gamble.personal_account_number 
where member_idx in (select idx from member where u_business = 1 and level = 2)
order by member_idx desc;*/

-- 업데이트
/*UPDATE personal_account_number SET account_bank_1 = '신협'
where member_idx in (select idx from member where u_business = 1 and level = 2)*/

-- 개인계좌1 계좌번호만 초기화
UPDATE personal_account_number SET account_number_1 = default where member_idx > 0