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=
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡ mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿ ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ ¿ÉÒÔÓÃÈ ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÔÌûÇë¿´ http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601 ×ܽáϾÍÊÇ apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......