Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySQL collation·½·¨

ÎÊÌâÊÇÕâÑùµÄ£º
Ò»ÕÅtestµÄ±í£¬×Ö·û¼¯²ÉÓõÄlatin1¡£
select to_id from test where to_id='cnÏó_Íõ';
+---------------+
| to_id |
+---------------+
| cnÌÕ_ÌÕ |
| cnÏó_Íõ |
+---------------+
2 rows in set (0.00 sec)
È¡cnÏó_ÍõµÄÊý¾Ý,¾ÓÈ»°ÑcnÌÕ_ÌÕµÄÊý¾ÝҲȡ»ØÀ´ÁË¡£
ÕâÏÔÈ»ÊDz»ÔÊÐíµÄ¡£
²é¿´ËüÃǵıàÂ룺
(root@im_offlog1a)[test]> select hex('cnÌÕ_ÌÕ');
+----------------+
| hex('cnÌÕ_ÌÕ') |
+----------------+
| 636ECCD55FCCD5 |
+----------------+
1 row in set (0.00 sec)
(root@im_offlog1a)[test]> select hex('cnÏó_Íõ');
+----------------+
| hex('cnÏó_Íõ') |
+----------------+
| 636ECFF35FCDF5 |
+----------------+
1 row in set (0.00 sec)
±àÂëµÄÈ·ÊDz»Ò»ÑùµÄ£¬µ«ÊÇΪʲômysql»áÈÏΪÕâÁ½Ìõ¼Ç¼ÊÇÒ»ÑùµÄÄØ£¿
Ò»¿ªÊ¼ÎÒÃǾͰÑÎÊÌⶨλÓÚcollationÒýÆðµÄÎÊÌâ¡£
show variables²é¿´
| collation_connection | latin1_swedish_ci
| collation_database | latin1_swedish_ci
| collation_server | latin1_swedish_ci
ÊÖ¹¤°ÑÕâЩ²ÎÊýÐÞ¸ÄΪlatin1_bin£¬½á¹û¾ÓȻһÑù¡£ÕâϸоõÕæÊÇÆæ¹ÖÁË¡£
ÕâÀïÏȽâÊÍÒ»ÏÂmysql collationµÄÃüÃû¹æÔò£º
ËüÃÇÒÔÆäÏà¹ØµÄ×Ö·û¼¯Ãû¿ªÊ¼£¬Í¨³£°üÀ¨Ò»¸öÓïÑÔÃû£¬²¢ÇÒÒÔ_ci£¨´óСд²»Ãô¸Ð£©¡¢_cs£¨´óСдÃô¸Ð£©»ò_bin£¨¶þÔª£©½áÊø
±ÈÈçlatin1×Ö·û¼¯ÓÐÒÔϼ¸ÖÖУÕý¹æÔò£º
У¶Ô¹æÔò º¬Òå
latin1_german1_ci µÂ¹úDIN-1
latin1_swedish_ci Èðµä/·ÒÀ¼
latin1_danish_ci µ¤Âó/ŲÍþ
latin1_german2_ci µÂ¹ú DIN-2
latin1_bin ·ûºÏlatin1±àÂëµÄ¶þ½øÖÆ
latin1_general_ci ¶àÖÖÓïÑÔ(Î÷Å·)
latin1_general_cs ¶àÖÖÓïÑÔ(Î÷Å·ISO),´óСдÃô¸Ð
latin1_spanish_ci ÏÖ´úÎ÷°àÑÀ
×îºóÎÒÃǽ«±í¸ñÖØ½¨£¬ÊÖ¹¤Ö¸¶¨±í¸ñ¼¶±ðµÄcollationΪlatin1_bin¡£
Õâ¸öÎÊÌâ¾ÍµÃµ½Á˽â¾ö¡£
ÄÇôÎÊÌâÓÖÀ´ÁË£¬ÎªÊ²Ã´ÎÒÇ°ÃæÊÖ¹¤²âÊÔlatin1_binʱ²»ÉúÐ§ÄØ£¿
Ô­À´MySQL°´ÕÕÏÂÃæµÄ·½Ê½Ñ¡Ôñ±í×Ö·û¼¯ºÍ У¶Ô¹æÔò£º
Èç¹ûÖ¸¶¨ÁËCHARACTER SET XºÍCOLLATE Y£¬ÄÇô²ÉÓÃCHARACTER SET XºÍCOLLATE Y¡£
Èç¹ûÖ¸¶¨ÁËCHARACTER SET X¶øÃ»ÓÐÖ¸¶¨COLLATE Y£¬ÄÇô²ÉÓÃCHARACTER SET XºÍCHARACTER SET XµÄĬÈÏУ¶Ô¹æÔò¡£
·ñÔò£¬²ÉÓ÷þÎñÆ÷×Ö·û¼¯ºÍ·þÎñÆ÷У¶Ô¹æÔò¡£
¶øÎÒÃÇÔÚ½¨±íµÄʱºòÖ¸¶¨ÁËcharacter set£¬ËùÒÔËüÓÀÔ¶ÊDzÉÓöÔÓ¦µÄĬÈϵÄУ


Ïà¹ØÎĵµ£º

LinuxÏÂMySQL5.1µÄ°²×°

×î½üÏëÔÚ·þÎñÆ÷ÉÏÊÔÊÔMySQL5.1µÄ·ÖÇø£¬ÓÚÊǾÍÏë×Å×°¸öMySQL5.1£¬¾­¹ýÍ´¿àµÄÒ»¶Î¾­Àúºó£¬ÖÕÓÚÕÒ¸öÏÂÃæ×°¸öºÜºÃµÄ½Ì³Ì£¬ÌûÉÏÀ´±¸Íü¡£
1¡¢MySQLÃâ°²×°°æ/¶þ½øÖưæÈí¼þ£¬²»ÓñàÒ룬ÏÂÔØµØÖ·£º
     http://dev.mysql.com/downloads/
     Îļþ¸ñʽ£ºMYSQL-VERSION-OS.tar.gz
2¡¢´ ......

mysql µ¼Èëµ¼³öÊý¾Ý·½·¨

1:>;create databases newname(ÔÚеÄserverÉϽ¨Á¢¿ÕµÄÊý¾Ý¿â)
2:#/usr/local/mysql/bin/mysqldump databasename >;*.sql(ÔھɵķþÎñÆ÷Éϵ¼³öÊý¾Ý¿â)
3:#/usr/local/mysql/bin/mysql databasename < *.sql(ÔÚеķþÎñÆ÷Éϵ¼Èë*.sql) ......

Linux Ï MysqlÅäÖÃÎÊÌ⼯

Ò»Ö±ÒÔÀ´ÎÒµÄÎÄÕ¶¼ÊÇÒÔ¹¤×÷±Ê¼ÇµÄÐÎʽ´æÔÚ¡£Õâ¶ÔÓÚ×Ô¼º¶ÁÆðÀ´Ã»Ê²Ã´´ó°­£¬µ«ÊǶÔÓÚÆäËû¶ÁÕß¿ÉÄܾÍÓÐЩÃÔã¡£ÎÒ¾¡Á¿¸Ä¸Ä£¬»»ÖÖ·½Ê½¡£
1. MySQL µÄ°æ±¾
Èç¹ûÒªÖ§³Ö·ÖÇø±í£¬ÔòÓ¦¸ÃʹÓà5.1.x ÒÔÉϵİ汾¡£Èç
mysql> show variables like '%version%';
+-------------------------+------------------------------ ......

Struts+Hibernate+MySqlÖÐÎÄÂÒÂë½â¾ö·½°¸

1¡¢ÐÞ¸ÄMySqlÊý¾Ý¿âµÄmy.iniÅäÖÃÎļþ¡¢
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If yo ......

mysqlÃüÁîÐÐ HAVING×Ó¾ä UNION

ÎÒÔÚmysql ÃüÁîÐÐÕâ¸öϵÁÐÀï½éÉܹýÓÐÌõ¼þ²éѯ£¬ËüÓõ½WHERE×Ӿ䡣µ«ÊÇÓÐʱºòÓÃWHERE×Ó¾äÎÞ·¨¸øÎÒÃǵIJéѯ¼ÓÈëÌõ¼þ£¬±ÈÈçÔÚÉÏÒ»½ÚÎÒÃÇѧϰµÄGROUP BY(°´×é¹éÀà)×Ӿ䣬Èç¹ûÎÒÃÇÒªÔÚ°´×é¹éÀàºó¼ÓÈëÌõ¼þ£¬ÓÃWHERE¾ÍÐв»Í¨£¬ÒòΪWHEREÖ»¿ÉÒÔÔÚ°´×é¹éÀàǰ¼ÓÈëÌõ¼þ¡£ºÃÔÚmysqlÌṩHAVING×Ӿ䣬Ëü¿ÉÒÔ°ïÎÒÃǽâ¾öÕâ¸öÎÊÌâ¡£
ÈçºÎÊ¹Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ