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µÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......
ÎÒÓõÄlikeÄ£ºý²éѯ£¬±ÈÈçmysqlµÄnameÖÐÓС°csdnÂÛ̳ϵͳ¡±Õ⼸¸ö×Ö£¬ÈçºÎÔÚ <input>Öвéѯ¡°csdn ϵͳ¡±Ò²ÄܳöÀ´Õâ¸ö¡°csdnÂÛ̳ϵͳ¡±£¬ÎÒÏÖÔÚÊDz顰csdn¡±»òÕß¡°ÏµÍ³¡±¶¼¿ÉÒÔ¡£Ð»Ð»¸÷λÁË£¡²»ÖªµÀÎÒÕâô±í´ï ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
½¨±í£º²å¼Ç¼
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
......
SQL code:
CREATE PROCEDURE A()
BEGIN
DECLARE 'Constraint Violation'
CONDITION FOR sqlexception;
DECLARE EXIT HANDLER FOR
'Constraint Violation' ROLLBACK;
BEGIN TRAN ......