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

·Î±×ÀÎ Category
MySQL Äõ¸®(Query) ƯÁ¤ÇÑ °ª ¼öÁ¤ ¹× »èÁ¦Çϱâ
°ü¸®ÀÚ  2010-12-23 03:30:18 Hit:4051
¸µÅ© #1: http://jjjboard.com/zb/zboard.php?id=mysql&page=2&sn1=&divpage=1&sn=off&ss=on&sc=on&select_arrange=headnum&desc=asc&no=2



Å×ÀÌºí¿¡¼­ ƯÁ¤ÇÑ °ª ¼±ÅÃÇϱâ

# 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)
º»¹®Àμ⺻¹®¸ÞÀϹ߼Û
¡â JSP¸¦ ÀÌ¿ëÇÑ °£´ÜÇÑ ·Î±×ÀÎ ¸¸µé±â
¡ä MySQL Admin Tool ¾îµå¹ÎÅø
Copyright 1999-2025 Zeroboard / skin by ChanBi