다중 업데이트

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 : ··· : 38 : 39 : 40 : 41 : 42 : 43 : 44 : 45 : 46 : ··· : 58 : NEXT »