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

mysql¸ßÊÖÇë½ø

ÓÃphpMyAdmin¼àÊÓÊý¾Ý¿âÔËÐÐÇé¿ö£¬ÓÐЩÎÊÌ⣬Á½ÌìÁ˶¼Ã»½â¾öµô£¬Çë¸ßÊÖÖ¸µã£¬ÏÈÐÐл¹ý£¡
ÎÊÌâÃèÊöÈçÏ£º
      ±äÁ¿                      Öµ                                              ÃèÊö
1¡¢  Innodb_buffer_pool_reads    275          InnoDB ½øÐÐÂß¼­¶ÁȡʱÎÞ·¨´Ó»º³å³ØÖлñÈ¡¶øÖ´Ðе¥Ò³¶ÁÈ¡µÄ´ÎÊý¡£

2¡¢  Handler_read_rnd            4,513      ¸ù¾Ý¹Ì¶¨Î»ÖöÁÈ¡ÐеÄÇëÇóÊý¡£Èç¹ûÄãÖ´ÐкܶàÐèÒªÅÅÐòµÄ²éѯ£¬¸ÃÖµ»áºÜ¸ß¡£Äã¿ÉÄÜÓкܶàÐèÒªÍêÕû±íɨÃèµÄ²éѯ£¬»òÕßÄãʹÓÃÁ˲»ÕýÈ·µÄË÷ÒýÓÃÀ´¶à±í²éѯ¡£

3¡¢  Handler_read_rnd_next      70 k        ´ÓÊý¾ÝÎļþÖжÁÈ¡ÐеÄÇëÇóÊý¡£Èç¹ûÄãÔÚɨÃèºÜ¶à±í£¬¸ÃÖµ»áºÜ´ó¡£Í¨³£Çé¿öÏÂÕâÒâζ×ÅÄãµÄ±íûÓÐ×öºÃË÷Òý£¬»òÕßÄãµÄ²éѯÓï¾äûÓÐʹÓúÃË÷Òý×ֶΡ£

4¡¢Created_tmp_disk_tables        858          ·þÎñÆ÷Ö´ÐÐÓï¾äʱ×Ô¶¯ÔÚ´ÅÅÌÉÏ´´½¨µÄÁÙʱ±íµÄÊýÁ¿¡£Èç¹û Created_tmp_disk_tables ºÜ´ó£¬Äã¿ÉÒÔÔö¼Ó tmp_table_size µÄÖµ£¬È÷þÎñÆ÷ʹÓÃÄÚ´æÀ´´æ´¢ÁÙʱ±í¶ø·Ç´ÅÅÌ¡£

5¡¢Key_reads                      1              ´Ó´ÅÅÌÖÐÎïÀí¶ÁÈ¡¼ü¿éµÄ´ÎÊý¡£Èç¹û Key_reads ºÜ´ó£¬Ô


Ïà¹ØÎÊ´ð£º

cÓïÑÔÈçºÎÁ¬½ÓMYSQL£¿

´ó¼ÒºÃ:
ÎÒÊǸãCµÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......

mysqlÄ£ºý²éѯÈçºÎ²éѯÁ½¸ö¹Ø¼ü×Ö

ÎÒÓõÄlikeÄ£ºý²éѯ£¬±ÈÈçmysqlµÄnameÖÐÓС°csdnÂÛ̳ϵͳ¡±Õ⼸¸ö×Ö£¬ÈçºÎÔÚ <input>Öвéѯ¡°csdn ϵͳ¡±Ò²ÄܳöÀ´Õâ¸ö¡°csdnÂÛ̳ϵͳ¡±£¬ÎÒÏÖÔÚÊDz顰csdn¡±»òÕß¡°ÏµÍ³¡±¶¼¿ÉÒÔ¡£Ð»Ð»¸÷λÁË£¡²»ÖªµÀÎÒÕâô±í´ï ......

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......

MYSQL 5.0£¬ÊÂÎñ»Ø¹öµÄÎÊÌâ

½¨±í£º²å¼Ç¼
SQL code:

create table tablename (id int,RQ1 datetime,RQ2 datetime)
-- select * from tablename
insert into tablename
select 1,'2009-01-01 10:00:00','2009-01-02 11:00:00' union
......

MYSQLÊÂÎñ»Ø¹öµÄÎÊÌâ

SQL code:

CREATE PROCEDURE A()
BEGIN
DECLARE 'Constraint Violation'
CONDITION FOR sqlexception;
DECLARE EXIT HANDLER FOR
'Constraint Violation' ROLLBACK;
BEGIN TRAN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ