Ȩ
ȣ
()
(ű)
/û
FAQ
ٶ
070-8260-2526
9 ~ 6
352-0331-1626-83
:ũڸ
ֹ
Ȩ > > ֹ
ȸ
8482
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
ֹ
¶λ
Ʈ