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

mysqlÖÐÎÄÂÒÂë

ÀûÓÃload data infileÃüÁîµ¼ÈëuserDesc.txtÊý¾Ý£¬Êý¾Ýµ¼ÈëºóËùÓеÄÖÐÎľÓȻȫÊÇÂÒÂ룬
mysql×Ö·û¼¯ÉèÖÃÈçÏ£º
    -> ;
+--------------------------+-------------------------------------------+
| Variable_name            | Value                                    |
+--------------------------+-------------------------------------------+
| character_set_client    | utf8                                      |
| character_set_connection | utf8                                      |
| character_set_database  | utf8                                      |
| character_set_filesystem | binary                                    |
| character_set_results    | utf8                                      |
| character_set_server    | utf8             


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

Mysql Êý¾Ý¿âɾ³ý²»ÁËÔõô°ì

ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿


ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©

......

½ô¼±ÇóÖú£ºmysql´´½¨Ë÷Òý³öÎÊÌâÁË

´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º

create uique index stu_cou_index on student_info.results (student_id, course_id);
show index from student_info.results;

±£´æÎªindex.s ......

Ôõô½«my-huge.iniÖеÄÅäÖñä³ÉmysqlµÄĬÈÏÅäÖã¿

ÏÖÓÐÒ»¸ö±íÓÐ185ÍòÌõ¼Ç¼
ËÑË÷ʱ£¬×î¸ß·åÖµ¿É´ï1.2G×óÓÒ
ʹÓÃmy-xxx.ini±È½ÏºÃ£¿£¡

ÈçºÎ½«ÕâЩÅäÖñä³ÉĬÈÏÅäÖã¿£¡
°ÑÔ­À´µÄ my.ini ¸ÄÃû±¸·Ý£¬È»ºóÔÙ°ÑÕâ¸ö  my-huge.ini ¸Ä³É my.ini

» ......

ѯÎÊ mysqlµÄÊý¾Ý¿â ¿âÃû³ÆÈçºÎ¸ü¸Ä

ѯÎÊ mysqlµÄÊý¾Ý¿â ¿âÃû³ÆÈçºÎ¸ü¸Ä
£¨±íÃûÊǺܼòµ¥µÄ£©
³¢ÊÔһϱäͨµÄ·½·¨£º

´´½¨Ò»¸öеÄÊý¾Ý¿âÃû³Æ

±¸·ÝÒªÐ޸ĵÄÊý¾Ý¿â£¬°Ñ±¸·ÝµÄÊý¾Ý»¹Ô­µ½Ð½¨µÄÊý¾Ý¿âÖÐ

²»¹ýÕâ¸öʵʱÐÔ²»ºÃ£¬½¨ÒéÔÚÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ