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=
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡ mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿ ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ ¿ÉÒÔÓÃÈ ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË. »¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£ ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
ÏÖÔÚÎÒÏë°Ñ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 ......