070-8260-2526

ÆòÀÏ ¿ÀÀü 9½Ã ~ ¿ÀÈÄ 6½Ã
´ÜÀ§³óÇù

352-0331-1626-83

¿¹±ÝÁÖ:°­¸¸¼öÅ×Å©³ÝÄÚ¸®¾Æ


ÀÚÁÖ¹¯´Â Áú¹®
Ȩ > °í°´¼¾ÅÍ > ÀÚÁÖ¹¯´Â Áú¹®

Á¶È¸¼ö 8295
Áú¹® MySQL ±âº»Äõ¸® : DELETE ¹®
MySQL ±âº»Äõ¸® : DELETE ¹® 
 

Äõ¸® ¸í·ÉÀ» ½ÇÇàÇÏ·Á¸é

1,
[Àüü°ü¸®]¡æ[DB°ü¸®]¡æ[Å×ÀÌºí °ü¸®] ÆäÀÌÁö¿¡¼­ ¿ìÃøÇÁ·¹ÀÓ ÇÏ´Ü¿¡
[MySQL Äõ¸®½ÇÇà] ¹öÆ°À» Ŭ¸¯ÇÏ°í, 
delete from ABCDE where no='3'
ó·³ Á÷Á¢ Äõ¸®¹®À» ÀÔ·ÂÇÏ°í [½ÇÇà] ¹öÆ° Ŭ¸¯ÇÏ¸é µË´Ï´Ù.
 
2,
º°°³ÀÇ php ÆÄÀÏÀ» ¸¸µé¾î¼­ ½ÇÇàÇÏ·Á¸é
<?
include "./lib.php";      // db Á¢¼Ó
mysql_query(" delete from ABCDE where no='3' ");    // Äõ¸®½ÇÇà
?>
ó·³ Äڵ带 ÀÛ¼ºÇÏ¿©
technote7/test.php À§Ä¡¿¡ ÆÄÀÏÀ» ¿Ã¸®°í,  À¥ºÎ¶ó¿ìÀú¿¡¼­ 
http;//abcd.com/technote7/test.php
¿Í °°ÀÌ Á¢¼ÓÇÏ¸é ½ÇÇàµË´Ï´Ù.

µ¥ÀÌŸ À¯½ÇÀÇ À§Ç輺ÀÌ ÀÖÀ¸´Ï È®½ÇÄ¡ ¾ÊÀº Äõ¸®¹®Àº Àý´ë ½ÇÇàÇÏÁö ¸¶½Ê½Ã¿À.



 
delete from ABCDE where no='3'
'ABCDE' Å×ÀÌºí¿¡¼­ 'no' Ä÷³°ªÀÌ '3' ÀÎ ·¹Äڵ带 ÀüºÎ »èÁ¦ÇÑ´Ù.

 
delete from ABCDE where no>3
'ABCDE' Å×ÀÌºí¿¡¼­ 'no' Ä÷³°ªÀÌ '3' º¸´Ù Å« ·¹Äڵ带 ÀüºÎ »èÁ¦ÇÑ´Ù.

 
delete from ABCDE where no<>3
'ABCDE' Å×ÀÌºí¿¡¼­ 'no' Ä÷³°ªÀÌ '3' ÀÌ '¾Æ´Ñ' ·¹Äڵ带 ÀüºÎ »èÁ¦ÇÑ´Ù.

 
delete from ABCDE where wdate>32015467 order by no limit 30
'ABCDE' Å×ÀÌºí¿¡¼­ 'wdate' Ä÷³°ªÀÌ '32015467' º¸´Ù Å« ·¹Äڵ带 'no' Ä÷³°ªÀ» ±âÁØÀ¸·Î
Á¤·Ä½ÃÄѼ­ »óÀ§ 30 °³¸¦ »èÁ¦ÇÑ´Ù.

 
delete from ABCDE where tbody like '%¹«·áµ¿¿µ»ó%'
'ABCDE' Å×ÀÌºí¿¡¼­ 'tbody' Ä÷³°ª¿¡ '¹«·áµ¿¿µ»ó' À̶õ ´Ü¾î°¡ Æ÷ÇÔµÈ ·¹Äڵ带 ÀüºÎ »èÁ¦ÇÑ´Ù.


delete from ABCDE where tbody like '%¹«·áµ¿¿µ»ó%' or subject like '%±¤°í%'
'ABCDE' Å×ÀÌºí¿¡¼­ 'tbody' Ä÷³°ª¿¡ '¹«·áµ¿¿µ»ó' À̶õ ´Ü¾î°¡ Æ÷ÇԵǾî Àְųª
'subject' Ä÷³°ª¿¡ '±¤°í' ¶ó´Â ´Ü¾î°¡ Æ÷ÇÔµÈ ·¹Äڵ带 ÀüºÎ »èÁ¦ÇÑ´Ù.
 


manual : http://dev.mysql.com/doc/refman/5.0/en/delete.html