|
|
ÇöÀçÀ§Ä¡: ¸ÞÀÎ ÇØÇÇÆ÷·³ À¥µðºñ : °Ô½Ã¹° Àбâ |
|
|
  2001-04-07 (02:35:07) from 211.187.191.138 |
|
|
  ÀÛ¼ºÀÎ : HappyCGI |
Á¶È¸¼ö : 6453    |
|
Á¦¸ñ : Mysql int¿Í varchar ±×¸®°í order by °Ë»ö¼ÓµµÂ÷ |
¾È³çÇϼ¼¿ä. ÇØÇÇCGI À¥¸¶½ºÅÍ À±¿µ¿õÀÔ´Ï´Ù. ¿äÁò ÇÑâ mysql ¼ÓµµÂ÷¿¡ ´ëÇؼ ±Ã±ÝÀÌ ÁõÆøµÇ¾ú³×¿ä. ^^ ¿À´Ã Á¦°¡ Å×½ºÆ®Çغ» ȯ°æÀº ¸®´ª½º/¸Þ¸ð¸®256M/CPU 700Mz ÀÔ´Ï´Ù. Å×À̺íÀÇ Ä÷³Àº ¾à 11°³Á¤µµ±¸¿ä. 50¸¸°ÇÀÇ ±ÛÀ» °Á¦·Î Áý¾î³Ö¾ú½À´Ï´Ù.
select ¹®À» ¼öÇàÇÔ¿¡ ÀÖ¾î¼ limit ÇÔ¼ö´Â ¼Óµµ¿¡ ¿µÇâÀÌ ¾ø¾ú½À´Ï´Ù. ÆäÀÌÁö ºÐÇҽà ²À limit¸¦ ½á¾ß ÇÏ°Ú´Ù´Â »ý°¢ÀÌ µé¾ú±¸¿ä. (´ç¿¬ÇÏÁö¸¸)
int Ä÷³ (number)À» order by ¾øÀÌ ÀÐÀ¸¸é 0.00ÃÊ´ë order by desc ÇßÀ» °æ¿ì 2.3 ÃÊ´ë°¡ ³ª¿À´Â±º¿ä. (number´Â ÀÍÅؽº ½ÃÅ°Áö ¾ÊÀ½ -> ½ÃÄѼ Çغ»°á°ú 0.00ÃÊ) varchar Ä÷³ (title)À» order by ÇßÀ» °æ¿ì 3.5ÃÊ´ë int ¿Í varchar Ä÷³À» µ¿½Ã¿¡ order by ÇßÀ» °æ¿ì 3.5ÃÊ È¤Àº ±× ÀÌ»ó. int Ä÷³°ú double Ä÷³ µ¿½Ã¿¡ order by ÇßÀ» °æ¿ì 2.7ÃÊ´ë ȤÀº ±× ÀÌ»ó
Á¤¸®¸¦ Çغ¸¸é... 1.À妽ÌÀº ²À ½ÃÅ°ÀÚ. 2.double µµ varchar¿Í ºñ½ÁÇÑ ¼Óµµ¸¦ °¡Áø´Ù. order by ½Ã µÉ¼ö ÀÖÀ¸¸é »©ÀÚ. 3.limit´Â select ¼Óµµ¿¡ °ÅÀÇ ¿µÇâÀ» ¹ÌÄ¡Áö ¾Ê´Â´Ù.
ÀÌ»óÀÔ´Ï´Ù. ^^
¿À¶óŬÀÌ ½½½½ ŽÀÌ ³ª±â ½ÃÀÛÇÏ´Â ±º¿ä. ^^
HappyCGI's SIGN
| °³¹ßÀÚÀÇ ¹Ì´öÀº
°ÔÀ¸¸§(Laziness) ÂüÁö¸»±â(Impatience) ±³¸¸(Hubris) |
|
|
|
¸Þ¸ð |
|
³²°ÜÁø ¸Þ¸ð°¡ ¾ø½À´Ï´Ù.
|
|
   |
|
|