ÔÚwindows7ÖдApache+PHP+MySQLƽ̨
½ñÌì¸ãÁËÒ»ÏÂÎ磬ÔÚµçÄÔÉϴÁËAPMƽ̨
ϵͳ:Windows7 Professional EN
Apache2.2.9:http://archive.apache.org/dist/httpd/binaries/win32/apache_2.2.9-win32-x86-openssl-0.9.8h-r2.msi
PHP5.3.1:http://windows.php.net/downloads/releases/php-5.3.1-Win32-VC6-x86.zip
MySQL5.1.42:http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.1/mysql-5.1.42-win32.msi
×¢Ò⣺PHP5.3.1ÓжàÖÖ£¬Ò»ÖÖÊÇfor VC9µÄ£¬ÔËÐл·¾³ÊÇIIS¶ø²»ÊÇApache£¬Èç¹ûÒªÓÃApache£¬¾ÍÖ»ÄÜÑ¡VC6µÄ¡£
ΪÁ˽ñºóÒÆÖ²µÄ·½±ã£¬ÎÒÖØж¨ÒåÁËĿ¼½á¹¹£º
<F:\>
|--<www>
| |--<server> # °²×° Web ·þÎñ³ÌÐò
| | |--<apache> # Apache°²×°Ä¿Â¼
| | |--<mysql> # MySql°²×°Ä¿Â¼
| | |--<php> # PHP°²×°Ä¿Â¼
| |
| |--<web> # ÍøÕ¾ÄÚÈÝ
| | |--<PHP³ÌÐò>
ÔÚ Windows7 Ï°²×° Apache 2.2.9
ÔËÐÐ apache 2.2.4 µÄ°²×°³ÌÐò£¬¸ù¾ÝÌáʾһ· Next ¼´¿É¡£×¢ÒâÔÚ Server Information µÄ Network Domain¡¢Server Name ×Ö¶ÎÌîÉÏ localhost£¬ÎÒ»¹ÖØÐÂÉ趨ÁËapacheµÄ¶Ë¿ÚºÅΪ8080¡£
ÔÚ°²×°ÀàÐ͵ÄλÖÃÑ¡ Custom£¬È»ºó¸Ä±ä°²×°Â·¾¶£¨ÎÒµÄĿ¼ÊÇ F:/www/server/apache£©¡£È»ºó¸ù¾ÝÌáʾһ· Next Íê³É¼´¿É¡£
È»ºóÔÚÃüÁîÌáʾÐÐÖдòÈëÏÂÁÐÃüÁÐèÒªÒÔ¹ÜÀíÔ±Éí·Ý´ò¿ªÃüÁîÌáʾÐУ©£º
# °²×° apache ·þÎñ£º
F:\www\server\apache\bin\> httpd -k install
#Æô¶¯ apahce ·þÎñ
F:\www\server\apache\bin\> httpd -k start
ÔÚ Windows7 Ï°²×° php 5.3.1
½«ÏÂÔØµÄ ZIP °üÖ±½Ó½âѹ£¬ÎÒÖ±½Ó½«zip Îļþ½âѹµ½ F:\www\server\php Ŀ¼ÏÂÃæ¡£°²×° php ²»½¨ÒéʹÓà win32 °²×°³ÌÐò(Ö÷ÒªÊÇÒÔºó°²×°À©Õ¹Âé·³£©¡£
ÔÚ×ÊÔ´¹ÜÀíÆ
Ïà¹ØÎĵµ£º
°²×°µÄOSΪSolaris10,mysql °æ±¾ÊÇ5.1.38
Ò»¡¢Ê¹ÓÃRPM°ü½øÐа²×°
Ê×ÏÈ¿ÉÒÔ´Ó°²×°¹âÅÌÖлòÕßµ½mysqlµÄÍøÕ¾ÉÏÏÂÔضÔÓ¦°æ±¾µÄrpm°üÈçÏ£º
MySQL-server-community-5.1.38-0.rhel5.i386.rpm
MySQL-client-community-5.1.38-0.rhel5.i386.rpm
½Ó×ÅÎÒÃÇ¿ÉÒÔʹÓÃrpmÃü ......
1.select max(id) from user;
2.select last_insert_id() as id from user limit 1;
(Õâ¸ö²âÊԵķµ»ØidÒ»Ö±ÊÇ0£¬ÓеãÎÊÌâ)
3.´¢´æ¹ý³Ì
1£©
oracelÖÐ
create sequence seqID
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
nocache
order;
create or replace procedure ......
ÔÀí
QueryCache(ÏÂÃæ¼ò³ÆQC)ÊǸù¾ÝSQLÓï¾äÀ´cacheµÄ¡£Ò»¸öSQL²éѯÈç¹ûÒÔselect¿ªÍ·£¬ÄÇôMySQL·þÎñÆ÷½«³¢ÊÔ¶ÔÆäʹÓÃ
QC¡£Ã¿¸öCache¶¼ÊÇÒÔSQLÎı¾×÷ΪkeyÀ´´æµÄ¡£ÔÚÓ¦ÓÃQC֮ǰ£¬SQLÎı¾²»»á±»×÷Èκδ¦Àí¡£Ò²¾ÍÊÇ˵£¬Á½¸öSQLÓï¾ä£¬Ö»ÒªÏà²îÄÄÅÂÊÇÒ»¸ö×Ö·û£¨ÀýÈç´óСд²»Ò»Ñù£»¶àÒ»¸ö¿Õ¸ñµÈ£©£¬ÄÇôÕâÁ½¸öSQL½«Ê¹Óò»Í¬µÄÒ» ......
Ç×°®µÄÕü¾ÈMySQLµÄÖйúÇ©ÃûÖ§³ÖÕß:
Å·ÃË¿ÉÄÜÎÞ·¨Õü¾ÈMySQL, ÖйúºÍ¶íÂÞ˹¿ÉÄÜÊÇÕü¾ÈMySQLµÄÏ£ÍûÖ®ËùÔÚ¡£ÖйúÓµÓÐÇ¿´ó¡¢¶ÀÁ¢ÒÔ¼°×ÔÐŵķ´Â¢¶ÏÖ÷¹Ü»ú¹Ø£¬Òò´Ë£¬ÎÒ±¾ÈËÔÚ´ËÇëÇóÄúµÄ°ïÖú¡£¶ÔÓÚÄúÔÚ http://helpmysql.org/cn/petition
µÄÇ©Ãû£¬ÎÒÃÇÉî±í¸Ðл¡£Èç¹û¿ÉÒԵĻ°£¬ÎÒÃÇÐèÒªÄúµÄ½øÒ»²½°ïÖú£º
&nb ......
1.ÐÞ¸ÄmysqlµÄĬÈϱàÂëΪgbk£ºÐÞ¸Ämy.initÎļþÖеģº[client]ºÍ[mysqld]ϵÄdefault-character-set=gbk£»
2.²é¿´mysqlÊý¾Ý¿âµÄ±àÂ룺show variable like 'character%';»òstatus
3.²é¿´Êý¾Ý¿â±íµÄ±àÂ룺show create table ±íÃû£»
4.ÐÞ¸ÄÊý¾Ý¿âµÄ±àÂ룺ALTER DATABASE `database_name` DEFAULT CHARACTER SET gbk COLLATE ......