Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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),  
    -> (


Ïà¹ØÎĵµ£º

mysqlÆô¶¯Åöµ½¹ýµÄÎÊÌâ

ÎÒµÄmysql×°ÔÚ/usr/local/mysqlĿ¼ÏÂÆô
¶¯Åöµ½¹ýºÜ¶àÎÊÌâ¡£×î³£¼ûµÄÊÇ£º
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
½â¾ö°ì·¨£º
[root@test mysql]# /usr/local/mysql/bin/mysqladmin -u root /
>  -S /var/lib/mysql/mysql.sock password 'your.passwd' ......

mysql Êý¾Ý¿âÒýÇæ

Èç¹ûÄãÊǸöÈü³µÊÖ£¬²¢ÇÒ°´Ò»Ï°´Å¥¾ÍÄܹ»Á¢¼´¸ü»»ÒýÇæ¶ø²»ÐèÒª°Ñ³µ¿ªµ½³µ¿âÀïÈ¥»»£¬ÄÇ»áÊÇʲô¸Ð¾õÄØ£¿MySQLÊý¾Ý¿âΪ¿ª·¢ÈËÔ±Ëù×öµÄ¾ÍºÃÏñÊǰ´°´Å¥»»ÒýÇæ£»ËüÈÃÄãÑ¡ÔñÊý¾Ý¿âÒýÇæ£¬²¢¸øÄãÒ»Ìõ¼òµ¥µÄ;¾¶À´Çл»Ëü¡£ 
MySQLµÄ×Ô´øÒýÇæ¿Ï¶¨Êǹ»ÓÃÁË£¬µ«ÊÇÔÚÓÐЩÇé¿öÏ£¬ÆäËûµÄÒýÇæ¿ÉÄÜÒª±ÈÊÖÍ·ËùÓøüÊʺÏÍê³ÉÈÎÎñ¡£Èç¹ûÔ¸ ......

ÔõÑù½øÐÐMysqlÔ¶³ÌÁ¬½Ó


 ÔõÑù½øÐÐMysqlÔ¶³ÌÁ¬½Ó
ÎÒÓÃ:
grant all privileges on *.* to ´´½¨µÄÓû§Ãû@localhost identified by "ÃÜÂë";
flush privileges; \* ˢиղŵÄÄÚÈÝ*\
========================
mysqlĬÈÏÊDz»ÔÊÐíÔ¶³ÌÁ¬½ÓµÄ£¬ÒòΪÓкܴóµÄ°²È«Òþ»¼¡£¡£
ËùÒÔÐèÒªÊÖ¶¯Ôö¼Ó¿ÉÒÔÔ¶³Ì·ÃÎÊÊý¾Ý¿âµÄÓû§¡£
ÏÂÃæÊÇÁ¬½Ó·½Ê½£º
# m ......

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£©°²×°ÒÔÒ»¸ö»¶Ó­ ......

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

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