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

mysql ²éѯÖÐË÷ÒýµÄ¹ÖÎÊÌâ

SQL code:
explain select * from t_user where username like '%ÅÖ';

½á¹û:
+----+-------------+--------+-------+---------------+------------+---------+------+------+-----------------------
| id | select_type | table  | type  | possible_keys | key        | key_len | ref  | rows | Extra
           
+----+-------------+--------+-------+---------------+------------+---------+------+------+-----------------------
|  1 | SIMPLE      | t_user | index | NULL          | ind_second | 62      | NULL |    5 | Using where; Using

index |

possible_keys ÊÇ¿ÉÓõÄË÷Òý£¬key ÊÇÓõ½µÄË÷Òý
possible_keys Ϊnull ,key ¾Í²»¿ÉÄÜÓÐֵѽ

ÕâÊÇÄÄÀï³öÎÊÌâÁË£¿
show index from t_user;
show create table t_user;

Ìù³öÀ´¿´Ò»Ï¡£

ÒýÓÃ
show index from t_user;
show create table t_user;

Ìù³öÀ´¿´Ò»Ï¡£

½á¹û·Ö±ðÊÇÕâÑùµÄ£º
CREATE TABLE `t_user` (
  `userid` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(20) NOT NULL,
  PRIMARY KEY (`userid`),
  KEY `ind_second` (`userName`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

MYSQLÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......

mysqlÖÐÎÄÂÒÂë - C/C++ / C++ ÓïÑÔ

mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......

mysqlµÄÊý¾Ýµ¼Èëµ½sql2000ÖУ¬Çë½Ì¸÷λ¡£

ÏÖÔÚÎÒÏë°ÑmysqlÊý¾ÝÀïµÄÊý¾Ý¿âÃû£ºmysqlDB,±íÃû£ºcdb_members£¬×ֶΰüº¬name password headpic addtime jifen 
SQLÊý¾Ý¿âÀï Êý¾Ý¿âÃû£ºsq_ha315a ±íÃû£ºfs_ms_user ×Ö¶ÎÒ²°üº¬name password headpic addti ......

ÈçºÎÔÚC#ÀïʵÏÖMYSQL±¸·Ý¹¦ÄܵÄÖ÷´ÓÇл»£¨Ò»Ö÷Ò»´Ó£©

ÈçÌâ
²¹³äÏ£º
  ÎÞ³ÌÐò£¬¸øË¼Â·Ò²ÐУ»


1. ÏÈÅжÏ֮ǰµÄͬ²½ÊÇ·ñÍê³ÉÁË¡£ ###ÈçºÎÅжϣ¿
2. ½øÐÐCHANGE MASTER TO ²Ù×÷¡£###ÎÒÖªµÀ¿ÉÒÔÇл»³É±¸·Ý»ú£¬µ«ÊDz»ÖªµÀÈçºÎÇл»»ØÖ÷·þÎñÆ÷£¬
ÎÒµÄÓÊÏäÊÇdo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ