Ôε¹£¬mysqlµ¼³ö½Å±¾ÖÐÎı䡰?????¡±ÂÒÂëÔõô»ØÊÂ,¸÷λÓÐûÓÐʵ¼ÊµÄ½â¾ö·½°¸
ÓÐûÓÐËÖªµÀ°¡
Èç¹ûÄãµÄ×Ö·û¼¯ÊÇUTF8µÄ»°£¬ÓÃÖ§³ÖUTF8µÄÈí¼þ´ò¿ªTXTÊÔÊÔ
SHOW CREATE TABLE TT
¼ì²éÓÐÖÐÎĵÄ×Ö¶Î×Ö·û¼¯ÊÇʲô¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
{{ ......
ÏÖÓÐÒ»¸ö±í¼Ç¼ÊÇ£º8°ÙÍò
ÆäÖÐÓÐÒ»¸ö×ֶεÄÖµÊÇ£º123456|45666|7899|6333|45566|9663|66666
ËüµÄ¸ñʽÈçÉÏ¡£
ÎÒÏÖÔÚÐèÒªÅÐ¶Ï £ü Öеĵڶþ¸öÖµ ¼´ 45666 ´óÓÚ 10000µÄÈ«²¿¼Ç¼ֵ
ÎÒдµÄSQLÓï¾äÈçÏ£º
select * from table where substring_index(substring_index(iolog,'|',6),'|',-1)>10 ......
Õý³£Çé¿öÏ ÄÚÍøºÍÍâÍøÒѾʵÏÖÁËË«Ïòͬ²½ £¬È»¶øÓÐÒ»ÖÖÇé¿ö¾ÍºÜÓôÃÆÁË ¾ÍÊǵ±ÄÚÍø»»Á˸öipµÄʱºò ÍâÍø²»Äܼ°Ê±½âÎöµ½ÐÂip£¬ÔÚÕâÒ»¶Îʱ¼äÄÚ ÍâÍø×öµÄ¸üРͬ²½²»¹ýÀ´ ²»ÖªµÀÕâ¸öÔõ÷á½â¾ö
¾ßÌåÇé¿öÈçÏÂ
¹«Ë¾ÄÚÍøÓõĶ¯Ì¬ÓòÃûʵÏÖ½âÎöµÄ ¿ÉÒÔͨ¹ý abc.3322.org ½âÎöµ½ÄÚÍøµÄ 192.168.0.2 ÉÏÃæ
ËùÒÔͬ²½²ÎÊýÀï ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö·û¸®¸ÄΪGB2312»òGBK£¬²»ÒªÊ¹ÓÃĬÈϵÄ×Ö·û¼¯¡£¾Í²»´æÔÚÄã˵µÄÎÊÌâÁË¡£
Õâ¸öÂÒÂëµÄ¶«Î÷ºÜÄÑ˵ÊÇmysqlµÄÎÊÌ ......
²ÉÓÃPHP+MYSQL
±í company
userid name status
1 Ìì²Å 1
2 Ó¢ÐÛ 1
3 ¹í²Å 0
±í dp
gid userid sort1 sort2
1 &nbs ......
ÏëѰÇóÒ»ÖֱȽϰ²È«±È½Ï±ã½ÝµÄ¶¨ÆÚmysqlÊý¾Ý¿â±¸·Ý´æ´¢·½·¨£¬ÏÖÔÚÓÐ3ÖÖÏë·¨£º
1 ÓÃphpд´úÂ뱸·Ý
2 ÓÃcд´úÂ뱸·Ý
3 ͨ¹ý½Å±¾¶¨ÆÚ¿½±´Êý¾Ý¿âÎļþ±¸·Ý
Õ÷ÇóÒ»ÖÖ×î¼ÑµÄ·½·¨£º£©£¬´ó¼ÒÒ»ÆðÀ´Ì¸Ò»Ì¸°¡
http://topic.csdn.net/u/20091020/22/c51bb709-6dbc-4fd1-b874-077714ed547e.html
²Î¿¼Ò»ÏÂÕâ¸öÌù×ÓÖ ......