http://www.mysqlkorea.co.kr
Çѱ۸Ŵº¾ó 5.0 , Çѱ۸Ŵº¾ó 5.1 , MySQL 5.1 HA , »ç¿ëÀڸŴº¾ó
Çѱ۸Ŵº¾ó 5.0  
Çѱ۸Ŵº¾ó 5.1  
MYSQL 5.1 HA  
»ç¿ëÀڸŴº¾ó  
¿µ¹®¸Å´º¾ó  
ÃֽűÛ
mysql ¹é¾÷/º¹±¸ ¡¦
apm ¼³Ä¡ Çì¸Þ°í¡¦
mysql bin·Î±× °»¡¦
myxql °ü·Ã Áö¿ø ¡¦
MySQL 5.7¿¡¼­ ÇÁ¡¦
 
Çѱ۸Ŵº¾ó 5.1 > ¸Å´º¾óÁ¸ > Çѱ۸Ŵº¾ó 5.1
 

10.5.1. SQL ¸í·É¹®¿¡¼­ COLLATE »ç¿ëÇϱâ

COLLATE ±¸¹®À» »ç¿ëÇϸé, ºñ±³¿ë µðÆúÆ® ÄÝ·¹¼ÇÀ» ¹«½ÃÇÒ ¼ö ÀÖ°Ô µÈ´Ù. COLLATE ´Â SQL ¸í·É¹®ÀÇ ´Ù¾çÇÑ ºÎºÐ¿¡¼­ »ç¿ëµÇ¸ç, ¸î °¡Áö ¿¹¹®ÀÌ ¾Æ·¡¿¡ ÀÖ´Ù:

  • ORDER BY¸¦ »ç¿ëÇÑ °Í:

SELECT k

FROM t1

ORDER BY k COLLATE latin1_german2_ci;

  • AS¸¦ »ç¿ëÇÑ °Í:

SELECT k COLLATE latin1_german2_ci AS k1

FROM t1

ORDER BY k1;

  • GROUP BY¸¦ »ç¿ëÇÑ °Í:

SELECT k

FROM t1

GROUP BY k COLLATE latin1_german2_ci;

  • ÁýÇÕ ÇÔ¼ö¸¦ »ç¿ëÇÑ °Í:

SELECT MAX(k COLLATE latin1_german2_ci)

FROM t1;

  • DISTINCT¸¦ »ç¿ëÇÑ °Í:

SELECT DISTINCT k COLLATE latin1_german2_ci

FROM t1;

  • WHERE¸¦ »ç¿ëÇÑ °Í:

     SELECT *

     FROM t1

     WHERE _latin1 'Müller' COLLATE latin1_german2_ci = k;

     SELECT *

     FROM t1

     WHERE k LIKE _latin1 'Müller' COLLATE latin1_german2_ci;

  • HAVINGÀ» »ç¿ëÇÑ °Í:

SELECT k

FROM t1

GROUP BY k

 
HAVING k = _latin1 'Müller' COLLATE latin1_german2_ci;
ȗˤ
10.5.1. SQL ¸í·É¹®¿¡¼­ COLLATE ¡¦
MySQL Korea »çÀÌÆ®ÀÇ ÄÁÅÙÃ÷ ¼ÒÀ¯±ÇÀº (ÁÖ)»ó»óÀ̺ñÁî¿¡ ÀÖÀ¸¹Ç·Î ¹«´ÜÀüÀ縦 ±ÝÇÕ´Ï´Ù.
¨Ï 2010-2011 ssebiz All Rights Reserved.