0
 45   5   1
  View Articles

Name  
   ¼Õº´¸ñ  (2002-05-07 14:21:31, Hit : 17227, Vote : 2926)
Homepage  
   http://www.itmembers.net
Subject  
   DML(Data Manipulation Language) - DELETE
UPDATE, INSERT¿¡ À̾î À̹ø ½Ã°£¿¡´Â Çà(·¹ÄÚµå)À» »èÁ¦ÇÏ´Â ¸í·ÉÀÎ DELETE ¸í·É¿¡ ´ëÇØ ¾Ë¾Æº¸°Ú½À´Ï´Ù.


  • DELETE´Â ƯÁ¤ Çà(·¹ÄÚµå)¸¦ »èÁ¦ÇÒ ¶§ »ç¿ëÇϸç, DELETE ¹®ÀÇ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.

    DELETE FROM table_name
    WHERE search condition(s);

  • À§ÀÇ ¹®ÀåÀ» º¸¸é ¾Æ½Ã°ÚÁö¸¸ DELETE ¹®¿¡´Â ƯÁ¤ Ä÷³ À̸§Àº ±â¼úÇÏÁö´Â ¾Ê½À´Ï´Ù. Áï Çà Àüü°¡ ¾Æ´Ñ ÇϳªÀÇ Çà(·¹ÄÚµå) Áß¿¡¼­ ÀϺΠÄ÷³¸¸ »èÁ¦ÇÒ ¼ö´Â ¾ø½À´Ï´Ù.
  • À§¿¡¼­ WHERE ÀýÀ» »ý·«ÇÏ¸é ¾î¶»°Ô µÉ±î¿ä?
    Å×À̺íÀÇ ¸ðµç ÇàÀÌ »èÁ¦µË´Ï´Ù.
  • ±×·¯³ª DELETE ¸í·ÉÀ¸·Î µ¥ÀÌÅÍ(Çà)¸¸ »èÁ¦ÇÒ ¼ö ÀÖÁö, Å×ÀÌºí ±¸Á¶´Â »èÁ¦ÇÒ ¼ö ¾ø½À´Ï´Ù. Å×À̺í ÀÚü¸¦ »èÁ¦ÇÏ·Á¸é DELETE°¡ ¾Æ´Ñ DROP ¸í·ÉÀ» »ç¿ëÇÕ´Ï´Ù.


´ÙÀ½°ú °°Àº Å×À̺íÀÌ ÀÖ´Ù°í °¡Á¤ÇØ º¾½Ã´Ù.
±×¸®°í ³ë¶õ»öÀ¸·Î Ç¥½ÃµÈ 10003, 10006, 10007¹ø ·¹ÄÚµå, Áï JOB_CODE°¡ 'SS'ÀÎ ·¹Äڵ带 »èÁ¦ÇØ º¼±î¿ä.


DELETE
FROM EMP
WHERE JOB_CODE = 'SS';

½±ÁÒ?

±×·³, À̹ø¿¡´Â Á¶±Ý °íÂ÷¿ø(?)ÀûÀÎ ¹®Á¦ Çϳª.
´ÙÀ½°ú °°Àº EMP Å×ÀÌºí¿¡¼­, EMP_SKILL Å×À̺íÀÇ EMP_NUMÀ» °¡Áö°í ÀÖÁö ¾ÊÀº Å×À̺íÀ» ¸ðµÎ »èÁ¦ÇÏ·Á¸é ¾î¶»°Ô ÇØ¾ßÇÒ±î¿ä?



ÀÌ·² ¶©, SUBSELECT ¹®À» ½á¾ß°ÚÁÒ.
Á÷Á¢ Çѹø »ý°¢ÇØ º¸½Å ´ÙÀ½, Á¤´äÀ» º¸½Ã·Á¸é ¾Æ·¡ ºó Ä­À» ¸¶¿ì½º·Î µå·¡±×ÇØ º¸¼¼¿ä.

DELETE
FROM EMP
WHERE EMP_NUM NOT IN
    (SELECT EMP_NUM
     FROM EMP_SKILL );


ÀÌ»ó µ¿ÁÖ ¾Æºü ¼Õº´¸ñÀ̾ú½À´Ï´Ù.

Prev
   Æ®·£Àè¼Ç(Transaction) Control Language - COMMIT, ROLLBACK, SAVEPOINT

¼Õº´¸ñ
Next
   DML(Data Manipulation Language) - INSERT

¼Õº´¸ñ


Copyright 1999-2026 Zeroboard / skin by Zetyx