mysqlµ¼Èëʱ³öÏÖÂÒÂë
ÎÒµÄmysqlÊý¾Ý¿â¡¢±í¡¢×ֶζ¼Ñ¡ÔñµÄÊÇgbk_chinese_ci£¬ÎÒµ¼³öʱÊÇ×÷ΪÎļþµ¼³öµÄ¡£ ºóÃæÒ²ÓÐ DEFAULT CHARSET=gbk¡£ ¾ÍÊÇÕû¸öÎļþµ¼Èëʱ£¬µ¼ÈëµÄËùÓкº×Ö¶¼ÂÒÂë¡£µ«ÎÒµ¥¶À¸´ÖÆÒ»¸ö±íinset intoºóµÄÄÚÈÝʱ£¬¾Í²»»áÂÒÂë¡£ ÎÒÊÇÄÄÀï³öÏÖÎÊÌâÁË£¿Ð»Ð»£¡£¡£¡ ×ܶøÑÔÖ®£¬ÑÔ¶ø×ÜÖ®¾ÍÊǶà±íͬʱµ¼Èëʱ£¨Õû¸öÎļþ£©»á³öÏÖÂÒÂ룬µ¥±íµ¼Èëʱ²»ÂÒ¡£¡£
Äã³¢ÊÔһϣ¬°ÑÓï¾äÖ±½ÓÔÚphpmyadminÀïÃæÔËÐС£²»Í¨¹ýÎı¾·½Ê½¡£¡£¡£¿´¿´Ð§¹ûÈçºÎ£¿ phpmyadminÀïÃæÔËÐÐ,Ó¦¸ÃûÎÊÌâµÄ¡£ ÒòΪÎÒµ¥±íÔËÐж¼Ã»ÎÊÌâ¡£¶à±íÒ»ÆðÔËÐеϰӦ¸ÃҲûÎÊÌâ¡£ Õâ¸ö±È½ÏµÄÓôÃÆ£¬ÒªËùÓеıàÂë¶¼Ò»Ñù²Å²»»á³öÏÖÂÒÂ룬µ«Ö»ÒªÊäÈëµÄ±àÂëºÍÊä³öµÄ±àÂëÒ»Ñù¾Í²»»áÔÚÒ³ÃæÊä³öÔì³ÉÂÒÂ룬ÓпÉÄÜÊý¾Ý¿âÀï»áÊÇÂÒÂ룬µ«²»Ó°ÏìÊä³öÒýÓà ÎÒµÄmysqlÊý¾Ý¿â¡¢±í¡¢×ֶζ¼Ñ¡ÔñµÄÊÇgbk_chinese_ci£¬ÎÒµ¼³öʱÊÇ×÷ΪÎļþµ¼³öµÄ¡£ ºóÃæÒ²ÓÐ DEFAULT CHARSET=gbk¡£ ¼ì²é¸ÃÎļþµÄ±àÂë Ëæ±ã¹ä¹ä¡£¡£¡£¡£UP UP ´ò¿ªµ¼³öµÄÎĵµ£¬ ¿´¿´ÀïÃæµÄ±àÂëÊÇʲô£¬ÔÙ°ÑÊý¾Ý¿âÉèÖúñàÂëµ¼È룬 Èç¹ûÊÇÎļþÊÇsql »òzipÒ»°ã¶¼ÄÜ¿´µ½µÄ µ«²»ÖªÄãÒÔʲô·½Ê½µ¼³ö£¬ ʲô·½Ê½µ¼Èë¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË. »¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£ ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ ¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ ÓóÌÐòÔ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿ MySQL 5.1²Î¿¼ÊÖ²á ÒýÓà ÐÖµÜÄã»á½áÌùÂ𣿠mysql ²Î¿¼ÊÖ²á baidu MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......