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;
Ìù³öÀ´¿´Ò»Ï¡£
½á¹û·Ö±ðÊÇÕâÑùµÄ£º
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=
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
ÏÖÔÚÎÒÏë°ÑmysqlÊý¾ÝÀïµÄÊý¾Ý¿âÃû£ºmysqlDB,±íÃû£ºcdb_members£¬×ֶΰüº¬name password headpic addtime jifen
SQLÊý¾Ý¿âÀï Êý¾Ý¿âÃû£ºsq_ha315a ±íÃû£ºfs_ms_user ×Ö¶ÎÒ²°üº¬name password headpic addti ......
ÈçÌâ
²¹³äÏ£º
ÎÞ³ÌÐò£¬¸øË¼Â·Ò²ÐУ»
1. ÏÈÅжÏ֮ǰµÄͬ²½ÊÇ·ñÍê³ÉÁË¡£ ###ÈçºÎÅжϣ¿
2. ½øÐÐCHANGE MASTER TO ²Ù×÷¡£###ÎÒÖªµÀ¿ÉÒÔÇл»³É±¸·Ý»ú£¬µ«ÊDz»ÖªµÀÈçºÎÇл»»ØÖ÷·þÎñÆ÷£¬
ÎÒµÄÓÊÏäÊÇdo ......