¸¶½ºÅÍÆ÷À¯(Master4U)
Monday, 17 of January
 

·Î±×ÀÎ Category
MySQL ±âº»Äõ¸® : DELETE ¹®
°ü¸®ÀÚ  2016-03-17 21:04:25 Hit:6311
¸µÅ© #1: https://www.technote.co.kr/php/technote1/board.php?board=faq&command=body&no=15


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

º»¹®Àμ⺻¹®¸ÞÀϹ߼Û
¡â MySQL ±âº»Äõ¸® : DELETE ¹® where
¡ä MYSQL¿¡·¯2
Copyright 1999-2025 Zeroboard / skin by ChanBi