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

PHPÔËÐл·¾³ÔÚWindowsϵÄÅäÖÃ(MySQLÅäÖã©

 Èí¼þÀë²»¿ªÊý¾Ý¿â£¬¶øPHP×î³£ÓõÄÊý¾Ý¿âÊÇMySQL¡£MySQLÊý¾Ý¿â·Ö·þÎñ¶ËºÍ¿Í»§¶Ë¡£
MySQL·þÎñ¶ËµÄ°²×°£º
(1)µã»÷MySQL°²×°°ü£¨´Ë´¦µÄ°²×°³ÌÐòΪmysql-5.0.18-win32.zip)
(2) ĬÈÏÊÇTypical,Èç¹ûÏëÐ޸ݲװ·¾¶µÄ»°Ò²¿ÉÒÔÑ¡Ôñcustom.
×¢Òâ:°²×°mysqlµÄ·¾¶ÖÐ,²»Äܺ¬ÓÐÖÐÎÄ!
(3)µã»÷intall¿ªÊ¼°²×°
(4)Ìø¹ý×¢²á
(5)ÊÇ·ñÏÖÔÚ¾ÍÅäÖà MySQL.Ò²¿ÉÒÔÖ®ºóÔÚ¿ªÊ¼²Ëµ¥µÄconfiguration wizard ½øÐÐÅäÖÃ.ÕâÀïÊÇÏÖÔÚ½øÐÐÅäÖÃ
(6)Ñ¡ÔñDetailed Configuration(ÏêϸÉèÖÃ),µãNext¼ÌÐø
(7)ÏÂÃæÕâ¸öÑ¡ÏîÊÇÑ¡ÔñmysqlÓ¦ÓÃÓÚºÎÖÖÀàÐÍ,µÚÒ»ÖÖÊÇ¿ª·¢·þÎñÆ÷,
½«Ö»Óþ¡Á¿ÉÙµÄÄÚ´æ,µÚ¶þÖÖÊÇÆÕͨWEB·þÎñÆ÷,½«Ê¹ÓÃÖеÈÊýÁ¿ÄÚ´æ,
×îºóÒ»ÖÖÊÇÕą̂·þÎñÆ÷ÉÏÃæÖ»ÔËÐÐMySQLÊý¾Ý¿â,½«Õ¼ÓÃÈ«²¿µÄÄÚ´æ.
Óû§¿É¸ù¾Ý×Ô¼ºµÄÐèÇó,Ñ¡ÔñÑ¡Ïî.ÕâÀïֻѡÔñ¿ª·¢·þÎñÆ÷,µãNext¼ÌÐø
(8)ÏÂÃæÊÇÑ¡ÔñÊý¾Ý¿âÓÃ;,µÚÒ»ÖÖÊǶ๦ÄÜÓÃ;,
½«°ÑÊý¾Ý¿âÓÅ»¯³ÉºÜºÃµÄinnodb(ÊÂÎñ)´æ´¢ÀàÐͺ͸ßЧÂʵÄmyisam(·ÇÊÂÎñ)´æ´¢ÀàÐÍ,
µÚ¶þÖÖÊÇÖ»ÓÃÓÚÊÂÎñ´¦ÀíÀàÐÍ,×îºÃµÄÓÅ»¯innodb,µ«Í¬Ê±Ò²Ö§³Ömyisam,Ö»ÓÐmyisam²ÅÖ§³ÖÈ«ÎÄË÷Òý
×îºóÒ»ÖÖÊǼòµ¥µÄÍøÂ翪·¢,ÊʺÏÓÚ¼òµ¥µÄÓ¦ÓÃ,Ö»Óв»Ö§³ÖÊÂÎñµÄmyisamÀàÐÍÊDZ»Ö§³ÖµÄ.
Ò»°ãÑ¡ÔñµÚÒ»Öֶ๦ÄܵÄ.
(9)ÏÂÃæÊÇÑ¡ÔñInnodDBµÄÊý¾Ý´æ·ÅλÖÃ,Ò»°ãĬÈϺÃÁË,²»ÐèÒª¸Ä¶¯(Èç¹ûÒªÐÞ¸ÄÊý¾Ý±£´æÂ·¾¶,Ò²¿ÉÓÃÔÚ°²×°ºóÐÞ¸Ämy.iniµÄdatadirµÄÖµ)
(10) ÏÂÃæÊÇÑ¡ÔñMySQLÔÊÐíµÄ×î´óÁ¬½ÓÊý,µÚÒ»ÖÖÊÇ×î´ó20¸öÁ¬½Ó²¢·¢Êý,
µÚ¶þÖÖÊÇ×î´ó500¸ö²¢·¢Á¬½ÓÊý,×îºó Ò»ÖÖÊÇ×Ô¶¨Òå,Äã¿ÉÒÔ¸ù¾Ý×Ô¼ºµÄÐèҪѡÔñ.
ÕâÀïÑ¡ÔñµÚÒ»¸ö
(11)ÏÂÃæÊÇÊÇ·ñÔËÐÐÍøÂçÁ´½Ó.ÕâÀïÑ¡Ôñ¸´Ñ¡¿ò.Êý¾Ý¿â¼àÌýµÄ¶Ë¿Ú,Ò»°ãĬÈÏÊÇ3306,
Èç¹û¸Ä³ÉÆäËû¶Ë¿Ú,ÒÔºóÁ¬½ÓÊý¾Ý¿âµÄʱºò¶¼Òª¼ÇסÐ޸ĵĶ˿Ú,·ñÔò²»ÄÜÁ¬½ÓmysqlÊý¾Ý¿â,
±È½ÏÂé·³,ÕâÀï²»×öÐÞ¸Ä,ÓÃmysqµÄĬÈ϶˿ڣº3306
(12)ÕâÒ»²½ÉèÖÃmysqlµÄĬÈϱàÂë,ĬÈÏÊÇlatin1,Ò²ÊDZê×¼µÄ±àÂë.µÚ¶þÖÖÊÇUTF8,µÚÈýÖÖÊÇÊÖ¶¯ÉèÖÃ.
±àÂëÊǰ汾4.1ÒÔÉÏÒýÈëµÄ.Èç¹ûÒªÓÃÔ­À´Êý¾Ý¿âµÄÊý¾Ý,×îºÃÄÜÈ·¶¨Ô­À´Êý¾Ý¿âÓõÄÊÇʲô±àÂë,Èç¹ûÕâÀïÉèÖõıàÂëºÍÔ­À´Êý¾Ý¿âÊý¾ÝµÄ±àÂë²»Ò»ÖÂ,ÔÚʹÓõÄʱºò¿ÉÄÜ»á³öÏÖÂÒÂë.½¨ÒéʹÓÃlatin1±ê×¼±àÂë
µ±È»ÎÒÃÇÓÐÐèÒªµÄ»°,Ò²¿ÉÒÔÐÞ¸ÄËüµÄ±àÂë(²»½¨Òé).
(13) ÕâÒ»²½ÊÇÊÇ·ñÒª°ÑmysqlÉèÖóÉwindowsµÄ·þÎñ,Ò»°ãÑ¡ÔñÉè³É·þÎñ,
ÕâÑùÒÔºó¾Í¿ÉÒÔͨ¹ý·þÎñÖÐÆô¶¯ºÍ¹Ø±ÕmysqlÊý¾Ý¿âÁË.ÍÆ¼ö£ºÏÂÃæµÄ¸´Ñ¡¿òÒ²¹´Ñ¡ÉÏ,
ÕâÑù,ÔÚcmdģʽÏÂ,²»±Ø·Çµ½mysqlµÄbinĿ¼ÏÂÖ´ÐÐÃ


Ïà¹ØÎĵµ£º

blogÔ´ÂëÕûÀí£ºphp+mysql²©¿Í³ÌÐò25ÖÖ

Blogϵͳ×÷Ϊ´ó¼Ò×î³£½Ó´¥µÄ»¥ÁªÍø¶«¶«£¬ÔÚÕ¾³¤ÈºÌåÖм¸ºõÈËÊÖÒ»²©£¬´ÓÖªÃûÃÅ»§µÄ²©¿ÍƵµÀ£¬µ½ÍøÂçÓªÏúר¼Ò²©¿Í£¬ÍøÃñ¶Ô²©¿ÍµÄ¹Ø×¢¶ÈÔÚ²»¶ÏÌá¸ß²¢É¡£Ä¿Ç°ÍøÉÏÃâ·ÑµÄblogϵͳ̫ÔÓ£¬ÔÚ´ËÕûÀíPHP°æµÄBlog½éÉÜÈçÏ£º
1¡¢wordpress:http://www.wordpress.org ¹¦ÄÜÒ²ºÜÈ«Ãæ£¬Ó¦¸ÃÊÇÖ§³ÖblogµÄÊ×Ñ¡¡£ËüÓÐ×îÇ¿µÄÄ£°æ¹¦ÄÜ£¬ÒѾ­ ......

¹Ø±ÕMYSQL´íÎóÌáʾÒô

×î½ü¹¤×÷Éϳ£Óõ½MySQL£¬·¢ÏÖMySQLµÄ´íÎóÌáʾÒô±È½Ï·³ÈË£¬ÉÏÍøËÑË÷ÁËһϣ¬ÓÐÒÔÏÂÈýÖֹرոÃÌáʾÒôµÄ·½·¨£º
·½·¨1. ʹÓÃÖÕ¶ËÃüÁî
   ʹÓÃMySQLµÄÃüÁîÖÕ¶Ëʱ£¬Ê¹ÓÃmysql --no-beep¼´¿É¡£
·½·¨2. ÐÞ¸ÄMySQLÅäÖÃÎļþmy.ini
    ÔÚ[mysql] ϼÓÈëÒ»ÐÐ
    no-beep
 &nb ......

MySQL Ë÷ÒýdzÎö

Ô­ÎÄÁ´½Ó£ºhttp://hi.baidu.com/171892549/blog/item/14818d0ac616ee34b1351dbd.html
ÔÚÊý¾Ý¿â±íÖУ¬Ê¹ÓÃË÷Òý¿ÉÒÔ´ó´óÌá¸ß²éѯËÙ¶È¡£
¼ÙÈçÎÒÃÇ´´½¨ÁËÒ»¸ö testIndex ±í£º
CREATE TABLE testIndex(i_testID INT NOT NULL,vc_Name VARCHAR(16) NOT NULL);
ÎÒÃÇËæ»úÏòÀïÃæ²åÈëÁË 1000 Ìõ¼Ç¼£¬ÆäÖÐÓÐÒ»Ìõ i_testID vc_Name ......

[ת]mysqlÐÔÄܵļì²éºÍµ÷ÓÅ·½·¨

ÎÒÒ»Ö±ÊÇʹÓÃmysqlÕâ¸öÊý¾Ý¿âÈí¼þ£¬Ëü¹¤×÷±È½ÏÎȶ¨£¬Ð§ÂÊÒ²ºÜ¸ß¡£ÔÚÓöµ½ÑÏÖØÐÔÄÜÎÊÌâʱ£¬Ò»°ã¶¼ÓÐÕâô¼¸ÖÖ¿ÉÄÜ£º
1¡¢Ë÷ÒýûÓн¨ºÃ£»
2¡¢sqlд·¨¹ýÓÚ¸´ÔÓ£»
3¡¢ÅäÖôíÎó£»
4¡¢»úÆ÷ʵÔÚ¸ººÉ²»ÁË£»
1¡¢Ë÷ÒýûÓн¨ºÃ
Èç¹û¿´µ½mysqlÏûºÄµÄcpuºÜ´ó£¬¿ÉÒÔÓÃmysqlµÄclient¹¤¾ßÀ´¼ì²é¡£
ÔÚlinuxÏÂÖ´ÐÐ
/usr/local/mysql/bin/ ......

MYSQL Íâ¼ü¶¨Òå




½¨Á¢Íâ¼üµÄǰÌ᣺ ±¾±íµÄÁбØÐëÓëÍâ¼üÀàÐÍÏàͬ(Íâ¼ü±ØÐëÊÇÍâ±íÖ÷¼ü)¡£
Íâ¼ü×÷Ó㺠ʹÁ½ÕűíÐγɹØÁª£¬Íâ¼üÖ»ÄÜÒýÓÃÍâ±íÖеÄÁеÄÖµ£¡
Ö¸¶¨Ö÷¼ü¹Ø¼ü×Ö£º foreign key(ÁÐÃû)
ÒýÓÃÍâ¼ü¹Ø¼ü×Ö£º references <Íâ¼ü±íÃû>(Íâ¼üÁÐÃû)
ʼþ´¥·¢ÏÞÖÆ: on deleteºÍon update , ¿ÉÉè²ÎÊýcascade(¸úËæÍâ¼ü¸Ä¶¯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ