다중 업데이트

Posted 2008. 6. 27. 18:04 by maxmini MAXMINI
UPDATE  TB_HMP_BOARD a
SET  a.WRITER_NICKNAME = (SELECT NICKNAME FROM TB_HMP_USER b WHERE a.WRITER_ID = b.ID)
WHERE  EXISTS (SELECT * FROM TB_HMP_USER b WHERE a.WRITER_ID = b.ID)
AND BOARD_ID='PHOTO'

Tag : , ,

Write your message and submit
« PREV : 1 : ··· : 3 : 4 : 5 : 6 : 7 : NEXT »