UPDATE COMTNGNRLMBER A
SET A.PASSWORD = (SELECT B.PASSWORD FROM COMTNGNRLMBER B WHERE B.MBER_ID = 'jc202100')
WHERE A.MBER_ID = 'jc000000'
;
by pajama
[2022.08.24 13:15:07]
UPDATE할때 같은 테이블을 서브쿼리에 사용하면 오류가 난다고 하네요.
한번 더 감싸주면 됩니다.
UPDATE COMTNGNRLMBER A
SET A.PASSWORD = (SELECT PASSWORD FROM
(SELECT B.PASSWORD FROM COMTNGNRLMBER B WHERE B.MBER_ID = 'jc202100') C
)
WHERE A.MBER_ID = 'jc000000';
by 마농
[2022.08.24 13:33:07]
UPDATE comtngnrlmber a
INNER JOIN comtngnrlmber b
ON a.mber_id = 'jc000000'
AND b.mber_id = 'jc202100'
SET a.password = b.password
;
http://gurubee.net/article/79308
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.