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

PHP/MYSQLʵÏÖ°´×Öĸ¼ìË÷

·½·¨Ò»£º½¨Ò»¸öÆ´Òô±í t_cosler £¬´æ·Åÿ¸ö×Öĸ¿ªÍ·µÄµÚÒ»¸öºº×ֵıàºÅºÍ×îºóÒ»¸öºº×ֵıàºÅ¡£   
BatchFile code+------+--------+-------+  
| f_PY | cBegin | cEnd  |  
+------+--------+-------+  
| A    |  45217 | 45252 |  
| B    |  45253 | 45760 |  
.....  
| Z    |  54481 | 55289 |  
+------+--------+-------+  
 
 
È»ºóÖ±½Ó²éѯ¾ÍÐÐÁË¡£   
 
SQL codemysql> create table t_cosler(  
    ->  f_PY char primary key,  
    ->  cBegin  SMALLINT UNSIGNED not null,  
    ->  cEnd    SMALLINT UNSIGNED not null  
    -> );  
Query OK, 0 rows affected (0.09 sec)  
 
mysql> insert into t_cosler values  
    -> ('A',0xB0A1,0xB0C4),  
    -> ('B',0xB0C5,0xB2C0),  
    -> ('C',0xB2C1,0xB4ED),  
    -> ('D',0xB4EE,0xB6E9),  
    -> ('E',0xB6EA,0xB7A1),  
    -> ('F',0xB7A2,0xB8C0),  
    -> ('G',0xB8C1,0xB9FD),  
    -> ('H',0xB9FE,0xBBF6),  
    -> ('J',0xBBF7,0xBFA5),  
    -> ('K',0xBFA6,0xC0AB),  
    -> ('L',0xC0AC,0xC2E7),  
    -> ('M',0xC2E8,0xC4C2),  
    -> ('N',0xC4C3,0xC5B5),  
    -> ('O',0xC5B6,0xC5BD),  
    -> ('P',0xC5BE,0xC6D9),  
    -> ('Q',0xC6DA,0xC8BA),  
    -> (


Ïà¹ØÎĵµ£º

windows»·¾³ÏµÄPHP+Apache+MySqlµÄ»·¾³´î½¨

²Ù×÷ϵͳ: windows xp
php°æ±¾:5.2.5 http://www.php.net/downloads.php
Apache http server °æ±¾:2.2.6http://httpd.apache.org/download.cgi
Mysql°æ±¾: 6.0.3http://dev.mysql.com/get/Downloads/MySQL-6.0
1.apacheµÄ°²×°:
1)Ë«»÷apache_2.2.6-win32-x86-no_ssl.msiͼ±ê£¬Æô¶¯apache°²×°³ÌÐò£»
2£©°²×°ÒÔÒ»¸ö»¶Ó­ ......

dz̸MySQLÂý²éѯÈÕÖ¾¼°microslow patch(msl patch)

       mysql(°üÀ¨ËùÓÐ5.*ϵÁÐ,5.1.21֮ǰ)µÄÂý²éѯÈÕ־ĬÈÏÊÇÒÔÃëΪµ¥Î»µÄ,¿ÉÒÔͨ¹ýset [session|global] long_query_time=1Õâ¸ö×îµÍÒ²¾ÍÊÇ¿ÉÒÔÉèÖõ½1Ãë,¶ÔÓÚ0.5,0.005Ö®Àà¾ÍÎÞÄÜΪÁ¦ÁË,Õâʱºò¿ÉÒÔÓÐmicroslow patch(msl patch)²¹¶¡À´Íê³ÉÕâÒ»¹¤×÷,Õâ¸ö¹¦Äܵĺô¦×ÔÈ»²»ÑÔ¶øÓ÷.
 &nb ......

cacti¼à¿ØmysqlÊý¾Ý¿âµÄ·½·¨

cacti ¼à¿Ø mysql
»·¾³£º
Cactiez»òÕßcactiÖ÷»ú£º192.168.12.5
±»¼à¿ØmysqlÊý¾Ý¿âÖ÷»ú£º192.168.5.231
1. °²×°¼à¿Ø²å¼þ
cd /opt
wget http://mysql-cacti-templates.googlecode.com/files/mysql-cacti-templates-1.1.6.tar.gz
tar -xzvf mysql-cacti-templates-1.1.2.tar.gz
cp /opt/mysql-cacti-templates-1.1.2 ......

MySQL(rootÓû§)ÃÜÂëÍü¼ÇÖØÖÃ(Windows/Linux)

MySQL(rootÓû§)ÃÜÂëÍü¼ÇÖØÖÃ
·Ö±ðÔÚWindowsϺÍLinuxÏÂÖØÖÃÁËMYSQLµÄrootµÄÃÜÂ룬ÕûÀíÈçÏ£º
¡¡¡¡A£ºÔÚwindowsÏ£º
¡¡¡¡1£º½øÈëcmd£¬Í£Ö¹mysql·þÎñ£ºNet stop mysql
¡¡¡¡   µ½mysqlµÄ°²×°Â·¾¶Æô¶¯mysql£¬ÔÚbinĿ¼ÏÂʹÓÃmysqld-nt.exeÆô¶¯£¬
¡¡¡¡2£ºÖ´ÐУºmysqld-nt --skip-grant-tables£¨´°¿Ú»áһֱֹͣ ......

һЩ±»ºöÊ PHP º¯Êý£¨ÕûÀí£©

ÕæµÄÊDz»Óò»ÖªµÀ£¬ÆäʵÎÒÃÇÊìϤµÄ PHP »¹ÓкܶàºÃ¶«Î÷ûÓз¢¾ò¡£¿´
µ½ÕâÆªÎÄÕÂ
£¬µ±Ê±¾ÍÀá±¼Á˺ü¸»Ø£¬ÖصãÍÆ¼öÏ£¬Ë³±ãÎÒ×Ô¼ºÒ²×ö¸öÕûÀí¡£
sys_getloadavg()
Õâ¸öº¯Êý
·µ»Øµ±Ç°ÏµÍ³µÄ¸ºÔؾùÖµÐÅÏ¢
£¨µ±È» Windows
ϲ»ÊÊÓã©£¬ÏêϸÎĵµ¿ÉÒÔ·­ÔÄ PHP µÄÏà¹ØÎĵµ¡£ÎĵµÖÐÓжÎʾÀý´úÂ룬»ù±¾ÉÏÒ²¾ÍÄÜ¿´³öËüµÄÓÃ;ÁË¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ