Å×ÀÌºí¿¡¼ ƯÁ¤ÇÑ °ª ¼±ÅÃÇϱâ
# SELECT * FROM Å×À̺í¸í
»èÁ¦Çϱâ
# delete from table¸í where Á¶°Ç
¼öÁ¤Çϱâ
# update Å×À̺í¸í set Ä®·³='Ä®·³°ª' where Á¶°Ç
Áߺ¹µÈ µ¥ÀÌŸ °É·¯³¿(distinct)
# SELECT distinct(zip_dong), zip_sido, zip_gugun FROM zipcode
(2004-11-04 21:41:41, Hit : 931, Vote : 270) |