½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > Ä¿¹Â´ÏƼ > Áú¹®°ú´äº¯ »ó¼¼º¸±â
Ä¿¹Â´ÏƼ ±¸Àα¸Á÷
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
Javascript
PHP
ASP
css
mysql
html
jquery
������
image
Mobile
API
slide
°Ô½ÃÆÇ
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
°Ô½ÃÆÇŸÀÌƲ Áú¹®°ú´äº¯ / »ó¼¼º¸±â
Æ®À§ÅÍ·Î º¸³»±â
Ãßõ¼ö 47 | Á¶È¸¼ö 4,377 | µî·ÏÀÏ 2001-04-07 02:35:07

´Ð³×ÀÓ

HappyCGI

À̸ÞÀÏ

hero@happycgi.com

Á¦¸ñ

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 ¼Óµµ¿¡ °ÅÀÇ ¿µÇâÀ» ¹ÌÄ¡Áö ¾Ê´Â´Ù.

ÀÌ»óÀÔ´Ï´Ù. ^^

¿À¶óŬÀÌ ½½½½ ŽÀÌ ³ª±â ½ÃÀÛÇÏ´Â ±º¿ä. ^^

Ãßõ½ºÅ©·¦¼Ò½ºº¸±â ¸ñ·Ï
ÀÌÀü°Ô½Ã±Û »ó¼¼ÇÑ ´äº¯¿¡ °¨»çµå¸³´Ï´Ù. 2001-04-07 01:12:21
´ÙÀ½°Ô½Ã±Û cgiÇÁ·Î±×·¥ ±¸ÇÕ´Ï´Ù.(±×¸² ÂüÁ¶) 2001-04-07 12:43:16