nginx+php cgi+mysqlÒ»¼ü°²×°°ü¸üаæ
[part1] http://download.csdn.net/source/2076258
[part2] http://download.csdn.net/source/2076272
[part3] http://download.csdn.net/source/2076276
[part4] http://download.csdn.net/source/2076283
[part02-04] http://www.ytgps.com/Images/nginx.rar
±¾ÎļþÌå»ý¹ý´ó·Ö4¸ö°ü£¬php-cgi+mysql+nginx.7z.001-.004¡£ÇëÏÂÈ«¡£ÏְѺóÃæ3¸ö°üÕûºÍÒ»¸ö°ü£¬http://www.ytgps.com/Images/nginx.rar
±¾°²×°ÎļþÐÞ¸ÄÁËÔ´ÂëÍøµÄ“CentOS ¼¯³Élinux+php-cgi+nginx+mysql°²×°°ü“ÀïÃæµÄ²¿·ÖÎļþ£¬Ö÷ÒªÊÇÐÞ¸ÄÁËinstall.shÄڵļ¸¸ö´íÎóλÖá£Ä¿Ç°ÎÒ²âÊÔÔÚcentos 5.4Ï£¬°²×°Ò»ÇÐÕý³££¡
ʹÓÃÕâ¸ö°²×°Ö®Ç°ÇëÒ»¶¨¿´Ò»Ï±¾ËµÃ÷Îļþ£¡
˵Ã÷£º
1¡¢±¾°²×°°ü²¢·Ç±¾ÈËÔ´´£¬½ö½öÊǶÔÔ°²×°°ü½øÐÐÁËһЩϸ΢µÄÐ޸ģ¬Èôó¼ÒÄܸü·½±ãµÄ°²×°nginx+php-cgi+mysqlƽ̨£¬½øÐвâÊÔºÍѧϰËùÓᣱ¾×ÅѧϰµÄ¾«Éñ£¬Ï£Íû´ó¼ÒÄܸü¿ìÕÆÎÕÕâ¸öƽ̨¡£
2¡¢ÎļþÈ«²¿½âѹËõµ½/usr/local/src,¶ø²¢·Ç/usr/src¡£ËùÒÔ´ó¼ÒÇë×¢ÒâÕâÒ»µã£¬ÒÔÃâÔÚÔËÐÐ./install.shµÄʱºòÔì³ÉÕÒ²»µ½ÎļþµÄÎÊÌâ¡£Èç¹ûÄãÏë½âѹËõµ½/usr/srcÀïÃ棬ÄǾÍÖ»ÓÐÔÙÐÞ¸ÄÒ»ÏÂ./install.shÀïÃæµÄ¼¸¸ö¶ÔÓ¦µÄµØ·½¾Í¿ÉÒÔÁË¡£Õâ¸öÆäʵÎÞËùν¡£Ö»ÒªÖªµÀÁ˾ͺÃÁË¡£
3¡¢°²×°Ö®Ç°È·¶¨£¬±¾»úûÓÐÔËÐÐmysql£¬È·¶¨Ã»ÓÐÀàËÆapacheµÈ³ÌÐòÕ¼ÓÃ80¶Ë¿Ú£¬Èç¹ûÓУ¬É±Ö®£¡
4¡¢Ô°²×°°üµÄ˵Ã÷Îĵµ£º
centos 5.2ÀïÒ»¼ü°²×° ¼¯³Élinux+php-cgi+nginx+mysql°²×°°ü£¬Ö»ÒªÖ´ÐÐÒ»ÏÂÀïÃæµÄinstall.sh¾Í¿ÉÒÔÍê³É°²×°£¡mysql rootÃÜÂëΪ¿Õ£¬°²×°Â·¾¶ÔÚ/usr/local/mysqlÀï
web·¾¶ÔÚ/var/www/html£¬Èç¹ûÏë¸ü¸ÄÖ»ÒªÐÞ¸Ä/usr/local/nginx/conf/nginx.confÀïrootµÄ·¾¶¾ÍÐÐÁË¡£
¸ÐлÏÂÔØ¡£±¾ÈËÒ²ÊÇÐÂÊÖ£¬Ï£Íû´ó¼Ò¹ÄÀø£¡ÔÚ´Ë£¬¸ÐлÔ×÷ÕßµÄÎÞ˽·ÖÏí£¡ËäÈ»ÎÒ²¢²»ÖªµÀÄúÊÇË£¡¸ÐлGNU£¡¸ÐлCSDN£¡±¾ÎļþÓÉÓÚÌå»ý¹ý´ó£¬ËùÒÔ´ò³É4¸ö°ü£¬·Ö±ðΪ£ºphp-cgi+mysql+nginx.7z.001¡¢php-cgi+mysql+nginx.7z.002¡¢php-cgi+mysql+nginx.7z.003¡¢php-cgi+mysql+nginx.7z.004¡£ÇëÏÂÔصÄÅóÓÑÒ»¶¨ÒªÏÂÔØÈ«¡£
Ïà¹ØÎĵµ£º
Éϴμ̱¾ÈË·¢²¼ÁËVC±àдPHPÀ©Õ¹Ö®Hello Worldƪºó£¬·´Ó³ºÜÇ¿ÁÒ£¬´ó¼Ò¶¼Ï£ÍûÄÜÍÑÀëPHP²ËÄñÐÐÁУ¬Õâ´ÎÎÒ¸ø´ó¼Ò´øÀ´PHPµ÷ÓÃC#±àдµÄCOM+×é¼þ¡£ COM+×é¼þÔ´´úÂë CODE:using System; using System.Collections.Generic; using System.Text; using System.Runtime.InteropServices; using System.Reflection; using System.Data.O ......
ÏÔʾËùÓÐÊý¾Ý¿â show databases;
´´½¨Êý¾Ý¿â create dababase stu;
ɾ³ýÊý¾Ý¿âdrop database stu;
Çл»µ½Êý¾Ý¿âuse stu;
È¡µÃµ±Ç°µÄÊý¾Ý¿â,´ø£¨£©±íʾº¯Êý:select database();
´´½¨±í£¨ÒªÇл»µ½Êý¾Ý¿âÖУ©
mysql> create table stu_info(
-> stu_id int(8) ......
1. mysql Ð޸ıíÃû×Ö
ALTER TABLE t1 RENAME t2;
2. ÐÞ¸ÄÁеÄÃû×Ö
>ALTER TABLE stock CHANGE COLUMN stock_id id INT(6);
3. Ôö¼ÓÁÐ
>ALTER TABLE ab ADD COLUMN id INT(3);
4. ¼õÉÙÁÐ
>ALTER TABLE ab DROP COLUMN id;
5. ÐÞ¸ÄÁ ......
¾ßÓиºÔؾùºâ¹¦ÄÜMySQL·þÎñÆ÷¼¯Èº²¿ÊðʵÏÖ
http://www.realure.cn/2009_241.html
http://www.realure.cn/2009_242.html
http://www.realure.cn/2009_243.html
http://www.realure.cn/2009_244.html
http://www.realure.cn/2009_245.html ......
1 MySQLÖ§³Öenum,ºÍsetÀàÐÍ£¬SQL Server²»Ö§³Ö
¡¡¡¡2 MySQL²»Ö§³Önchar,nvarchar,ntextÀàÐÍ
¡¡¡¡3 MySQLµÄµÝÔöÓï¾äÊÇAUTO_INCREMENT£¬¶øMS SQLÊÇidentity(1,1)
¡¡¡¡4 MS SQLĬÈϵ½´¦±í´´½¨Óï¾äµÄĬÈÏÖµ±íʾÊÇ((0)),¶øÔÚMySQLÀïÃæÊDz»ÔÊÐí´øÁ½À¨ºÅµÄ
¡¡¡¡5 MySQLÐèҪΪ±íÖ¸¶¨´æ´¢ÀàÐÍ
¡¡¡¡6 MS SQLʶ±ð·ûÊÇ[],[type]±íÊ ......