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

MySQL Ë÷ÒýdzÎö

Ô­ÎÄÁ´½Ó£ºhttp://hi.baidu.com/171892549/blog/item/14818d0ac616ee34b1351dbd.html
ÔÚÊý¾Ý¿â±íÖУ¬Ê¹ÓÃË÷Òý¿ÉÒÔ´ó´óÌá¸ß²éѯËÙ¶È¡£
¼ÙÈçÎÒÃÇ´´½¨ÁËÒ»¸ö testIndex ±í£º
CREATE TABLE testIndex(i_testID INT NOT NULL,vc_Name VARCHAR(16) NOT NULL);
ÎÒÃÇËæ»úÏòÀïÃæ²åÈëÁË 1000 Ìõ¼Ç¼£¬ÆäÖÐÓÐÒ»Ìõ i_testID vc_Name 555 erquan
ÔÚ²éÕÒ vc_Name="erquan" µÄ¼Ç¼ SELECT * from testIndex WHERE vc_Name='erquan'; ʱ£¬Èç¹ûÔÚvc_Name ÉÏÒѾ­½¨Á¢ÁËË÷Òý£¬MySql ÎÞÐëÈκÎɨÃ裬¼´×¼È·¿ÉÕÒµ½¸Ã¼Ç¼£¡Ïà·´£¬MySql »áɨÃèËùÓмǼ£¬¼´Òª²éѯ 1000¡£ÒÔË÷Òý½«²éѯËÙ¶ÈÌá¸ß 100 ±¶¡£
Ò»¡¢Ë÷Òý·Öµ¥ÁÐË÷ÒýºÍ×éºÏË÷Òý
µ¥ÁÐË÷Òý£º¼´Ò»¸öË÷ÒýÖ»°üº¬µ¥¸öÁУ¬Ò»¸ö±í¿ÉÒÔÓжà¸öµ¥ÁÐË÷Òý£¬µ«Õâ²»ÊÇ×éºÏË÷Òý¡£×éºÏË÷Òý£º¼´Ò»¸öË÷°üº¬¶à¸öÁС£
¶þ¡¢½éÉÜÒ»ÏÂË÷ÒýµÄÀàÐÍ
1¡¢ÆÕͨË÷Òý¡£
ÕâÊÇ×î»ù±¾µÄË÷Òý£¬ËüûÓÐÈκÎÏÞÖÆ¡£ËüÓÐÒÔϼ¸ÖÖ´´½¨·½Ê½£º
£¨1£©´´½¨Ë÷Òý£ºCREATE INDEX indexName ON tableName(tableColumns(length));Èç¹ûÊÇCHAR£¬VARCHARÀàÐÍ£¬length¿ÉÒÔСÓÚ×Ö¶Îʵ¼Ê³¤¶È;Èç¹ûÊÇ BLOB ºÍ TEXT ÀàÐÍ£¬±ØÐëÖ¸¶¨ length£¬ÏÂͬ¡£
£¨2£©Ð޸ıí½á¹¹£ºALTER tableName ADD INDEX [indexName] ON (tableColumns(length)) 
£¨3£©´´½¨±íµÄʱºòÖ±½ÓÖ¸¶¨£ºCREATE TABLE tableName ( [...], INDEX [indexName] (tableColumns(length)) ;
2¡¢Î¨Ò»Ë÷Òý¡£
ËüÓëÇ°ÃæµÄ"ÆÕͨË÷Òý"ÀàËÆ£¬²»Í¬µÄ¾ÍÊÇ£ºË÷ÒýÁеÄÖµ±ØÐëΨһ£¬µ«ÔÊÐíÓпÕÖµ¡£Èç¹ûÊÇ×éºÏË÷Òý£¬ÔòÁÐÖµµÄ×éºÏ±ØÐëΨһ¡£ËüÓÐÒÔϼ¸ÖÖ´´½¨·½Ê½£º
£¨1£©´´½¨Ë÷Òý£ºCREATE UNIQUE INDEX indexName ON tableName(tableColumns(length))
£¨2£©Ð޸ıí½á¹¹£ºALTER tableName ADD UNIQUE [indexName] ON (tableColumns(length))
£¨3£©´´½¨±íµÄʱºòÖ±½ÓÖ¸¶¨£ºCREATE TABLE tableName ( [...], UNIQUE [indexName] (tableColumns(length));
3¡¢Ö÷¼üË÷Òý
ËüÊÇÒ»ÖÖÌØÊâµÄΨһË÷Òý£¬²»ÔÊÐíÓпÕÖµ¡£Ò»°ãÊÇÔÚ½¨±íµÄʱºòͬʱ´´½¨Ö÷¼üË÷Òý£ºCREATE TABLE testIndex(i_testID INT NOT NULL AUTO_INCREMENT,vc_Name VARCHAR(16) NOT NULL,PRIMARY KEY(i_testID)); µ±È»Ò²¿ÉÒÔÓà ALTER ÃüÁî¡£¼Çס£ºÒ»¸ö±íÖ»ÄÜÓÐÒ»¸öÖ÷¼ü¡£
4¡¢È«ÎÄË÷Òý
MySQL ´Ó 3.23.23 °æ¿ªÊ¼Ö§³ÖÈ«ÎÄË÷ÒýºÍÈ«ÎļìË÷¡£
ɾ³ýË÷ÒýµÄÓï·¨£ºDROP INDEX index_name ON tableName
Èý¡¢µ¥ÁÐË÷ÒýºÍ×éºÏË÷Òý
ΪÁËÐÎÏóµØ¶Ô±ÈÁ½Õߣ¬ÔÙ½¨Ò»¸ö±í£º
CREATE TABL


Ïà¹ØÎĵµ£º

bind+dlz+mysqlʵÏÖÇøÓò¼Ç¼¶¯Ì¬¸üÐÂ


BIND-DLZʵÑé:http://bind-dlz.sourceforge.net/
ʵÑé»·¾³:RHEL4,BIND-9.5.0-P2.tar.gz(9.4.0ÒÔÉϰ汾¶¼ÒѺ¬DLZ²¹¶¡),Mysql-5.0.56.tar.gz
1¡¢°²×°mysql(ÏȰ²×°gccµÈÏà¹ØÈí¼þ°ü)
   #tar zxvf mysql-5.0.56.tar.gz 
   #cd mysql-5.0.56
   #./configure --prefix=/usr/local/my ......

´ÓDOSÇл»µ½mysql£º»·¾³±äÁ¿ÉèÖõÄÎÊÌâ


 
 
 
ÔÚWindowsXPÖдò¿ªDOS£¬Í¨¹ýÊäÈëÃüÁî“mysql -u root -p”Çл»µ½mysqlÏ£¬Çл»Ê§°Ü£¬ÈçÏÂËùʾ£º
Microsoft Windows XP [°æ±¾ 5.1.2600]
(C) °æÈ¨ËùÓÐ 1985-2001 Microsoft Corp.
C:\>mysql -u root -p
'mysql' ²»ÊÇÄÚ²¿»òÍⲿÃüÁҲ²»ÊÇ¿ÉÔËÐеijÌÐò
»òÅú´¦ÀíÎļþ¡£
  ......

mysql´íÎó¼°½â¾öÈ«¹¥ÂÔ

10055:ûÓлº´æ¿Õ¼ä¿ÉÀûÓà  ·½·¨:²é¿´ÏÂÄãµÄCÅ̿ռäÊÇ·ñÒѾ­Âú,Çå³ýһЩûÓÐÓõÄÎļþ.   ¿ÉÒÔÔÚºǫ́µÄ"ÂÛ̳ºËÐÄÉèÖÃ","ºËÐŦÄÜÉèÖÃ"Àï"½ø³ÌÓÅ»¯"¿ªÆô,"GZIP ѹËõÊä³ö"¹Ø±Õ. ²éÕÒÁËÒ»ÏÂ10055£¨Ã»Óлº´æ
˵Ã÷:Èç¹ûÓöµ½Êý¾Ý¿â³ö´íµÄÎÊÌâÐÞ¸ÄÏàÓ¦µÄ´úÂëºóÒ»°ãÒªÖØÆômysql¡£Èç¹ûÓöµ½mysqlµÄÎÊÌâ¿ÉÒÔÏÈÖØÆ ......

MySQL±àÂëÎÊÌâ

my.iniÎļþÅäÖ㺠[mysql] default-character-set=GBK #´Ë´¦µÄ±àÂëÊÇMySQL¿ØÖÆÌ¨ÏÔʾµÄ±àÂ뷽ʽ£¬Ó¦¸ÃÉèÖÃΪGBK [mysqld] default-character-set=utf8 #´Ë´¦µÄ±àÂëÊÇMySQLÊý¾Ý´æ´¢µÄ¸ñʽ£¬Ó¦¸ÃÉèÖÃΪutf8£¬¿ÉÒÔ´æ´¢ÊÀ½çÉϾø´ó¶àÊý×Ö·û ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ