ȨÆäÀÌÁö
À¥È£½ºÆÃ
À¯Áöº¸¼ö
µµ¸ÞÀÎ(±âÁ¸)
µµ¸ÞÀÎ(½Å±Ô)
¹®ÀÇ/¿äû
Áö½ÄFAQ
»êµé¹Ù¶÷¸ô
°í°´¼¾ÅÍ
FAQ
¹®ÀÇ/¿äû
°í°´Á¦¾È
À̺¥Æ®
ÀÚ·á½Ç
°øÁö»çÇ×
070-8260-2526
ÆòÀÏ ¿ÀÀü 9½Ã ~ ¿ÀÈÄ 6½Ã
´ÜÀ§³óÇù
352-0331-1626-83
¿¹±ÝÁÖ:°¸¸¼öÅ×Å©³ÝÄÚ¸®¾Æ
ÀÚÁÖ¹¯´Â Áú¹®
Ȩ > °í°´¼¾ÅÍ > ÀÚÁÖ¹¯´Â Áú¹®
Á¶È¸¼ö
8480
Áú¹®
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
¿ø°ÝÁ¦¾î
ÀÚÁÖ¹¯´ÂÁú¹®
¿Â¶óÀλó´ã
°ßÀû¹®ÀÇ
»çÀÌÆ®¸Ê