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

mysql°²×°Í¼½â½Ì³Ì 5.1(ת)

mysql°²×°Í¼½â½Ì³Ì 5.1
2009Äê03ÔÂ01ÈÕ ÐÇÆÚÈÕ 23:51
תÔØÇë×¢Ã÷³ö´¦:http://hi.baidu.com/herdff/blog/item/6e6b4bcf6132f90b93457e14.html
±¾½Ì³ÌÒÔMysql 5.1°æ±¾ÎªÀý£¬¸ü¸ß°æ±¾°²×°¹ý³ÌÓë´ËÀàËÆ¡£ÔĶÁÇ°£¬ÇëÏÂÔØ5.1£¬ÏÂÔصØÖ·£ºwww.mysql.com
°²×°¹ý³ÌÓëÆäËüWindows°²×°³ÌÐòÒ»Ñù£¬Ê×ÏȳöÏÖµÄÊÇ°²×°Ïòµ¼»¶Ó­½çÃæ
Ö±½Óµã»÷“Next”£¬¼ÌÐø£¬Ñ¡Ôñ°²×°ÀàÐÍ
ÕâÀïÓÐ3¸öÀàÐÍ£ºTypical£¨µäÐÍ£©¡¢Complete£¨ÍêÈ«£©¡¢Custom£¨×Ô¶¨Ò壩¡£Ñ¡Ôñ“×Ô¶¨Ò唣¨Custom£©°²×°£¬È»ºóµã“Next”ÏÂÒ»²½£¬³öÏÖ×Ô¶¨Òå°²×°½çÃæ
ÎÒÃÇÕâÀï¾Í°´ÕÕĬÈϵÄÕâ¸ö·¾¶¡£µã»÷“NEXT” ×¼±¸¿ªÊ¼°²×°
µã“Install”¿ªÊ¼°²×°
°²×°Íêºó³öÏÖ ½â˵»­Ã棬һֱÏÂÒ»²½
×¢Ò⣬ÕâÀïÓиöÅäÖÃÏòµ¼µÄÑ¡ÏConfigure the MySQL Server now£©£¬½¨Òé¹´Ñ¡Á¢¼´ÅäÖÃÄãµÄMySQL¡£Ðí¶à˵°²×°ÍêMySQLºóÎÞ·¨Æô¶¯£¬Ô­Òò¾ÍÔÚÓÚûÓÐÅäÖÃMySQL¡£µã»÷“Finish”Íê³É°²×°£¬²¢¿ªÊ¼ÅäÖÃMySQL
µã“Next”£¬½øÈëÅäÖÃÀàÐÍÑ¡ÔñÒ³Ã档ѡ“Detailed configuration”£¨ÏêϸÅäÖã©£¬
µã“Next”£¬½øÈë·þÎñÀàÐÍÑ¡ÔñÒ³Ã档ѡ“Developer Machine”£¨¿ª·¢Õß»úÆ÷£©£¬ÕâÑùÕ¼ÓÃϵͳµÄ×ÊÔ´²»»áºÜ¶à
µã“Next”ºó£¬½øÈëÊý¾Ý¿âÓ÷¨Ñ¡ÔñÒ³Ã档ѡÔñ“Multifunctional Database“
µã“Next”£¬½øÈëÑ¡ÔñInnoDBÊý¾Ý´æ·ÅλÖÃÒ³Ãæ
²»Óøü¸ÄÉèÖã¬Ö±½Ó·ÅÔÚInstallation Path°²×°Ä¿Â¼Àï¼´¿É£¬È»ºóµã“Next”£¬Ñ¡ÔñMySQLµÄͬʱÁª½ÓÊý
Ñ¡Ôñ“Manual Setting”£¬ÉèÖÃΪ100£¨¸ù¾Ý×Ô¼ºÐèÒª£¬×ÃÇéÉèÖã©£¬µã“Next”£¬ÅäÖÃMySQLÔÚTCP/IPͨѶ»·¾³ÖеĶ˿Ú
Ñ¡ÔñĬÈϵÄ3306¶Ë¿Ú¼´¿É¡£µã“Next”£¬Ñ¡ÔñMySQLÖеÄ×Ö·ûÉèÖÃ
×¢Ò⣬ÕâÀïµÄÑ¡Ôñ½«»áÓ°ÏìÄãÊÇ·ñÄÜÔÚMySQLÖÐʹÓÃÖÐÎÄ¡£ÎÒÃÇÑ¡ÔñGBKÖ§³ÖµÄ×Ö·û¼¯¶àһЩ¡£µã“Next”£¬ÉèÖÃWindows·þÎñÑ¡Ïî
×¢Ò⣬ÕâÀïµÄÑ¡ÔñºÜ¹Ø¼ü¡£“Install As Windows Service”Ò»¶¨Òª¹´Ñ¡£¬ÕâÊǽ«MySQL×÷ΪWindowsµÄ·þÎñÔËÐС£“Service Name”¾ÍÓÃĬÈϵēMySQL”»òÕßÄãϲ»¶µÄ·þÎñÃû£¨ÍƼöÓÃĬÈϵēMySQL”£©¡£ÏÂÃæµÄ“Launch the MySQL Server automatically”Ò»¶¨Òª¹´Ñ¡£¬ÕâÑùWindowsÆô¶¯Ê±£¬MySQL¾Í»á×Ô¶¯Æô¶¯·þÎñ£¬Òª²»È»¾ÍÒªÊÖ¹¤Æô¶¯MySQL¡£Ðí¶àÈË˵°²×°MyS


Ïà¹ØÎĵµ£º

Mysql ʱ¼äº¯Êý»ã×Ü

 Ò»¡¢MySQL »ñµÃµ±Ç°ÈÕÆÚʱ¼ä º¯Êý
1.1 »ñµÃµ±Ç°ÈÕÆÚ+ʱ¼ä£¨date + time£©º¯Êý£ºnow()
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2008-08-08 22:20:46 |
+---------------------+
³ýÁË now() º¯ÊýÄÜ»ñµÃµ±Ç°µÄÈÕÆÚʱ¼äÍ⣬MySQL Öл¹ÓÐÏÂÃæµÄº¯Êý£º
current_tim ......

MysqlÓÅ»¯·½°¸Ö®Ë÷ÒýµÄʹÓÃ

 
Ë÷ÒýÓÃÓÚ¿ìËÙÕÒ³öÔÚij¸öÁÐÖÐÓÐÒ»Ìض¨ÖµµÄÐС£²»Ê¹ÓÃË÷Òý£¬MySQL±ØÐë´ÓµÚ1Ìõ¼Ç¼¿ªÊ¼È»ºó¶ÁÍêÕû¸ö±íÖ±µ½ÕÒ³öÏà¹ØµÄÐС£±íÔ½´ó£¬»¨·ÑµÄʱ¼äÔ½¶à¡£Èç¹û±íÖвéѯµÄÁÐÓÐÒ»¸öË÷Òý£¬MySQLÄÜ¿ìËÙµ½´ïÒ»¸öλÖÃÈ¥ËÑÑ°µ½Êý¾ÝÎļþµÄÖм䣬ûÓбØÒª¿´ËùÓÐÊý¾Ý¡£Èç¹ûÒ»¸ö±íÓÐ1000ÐУ¬Õâ±È˳Ðò¶ÁÈ¡ÖÁÉÙ¿ì100±¶¡£×¢ÒâÈç¹ûÄãÐèÒª·ÃÎÊ ......

MySQL¶Ô±ê×¼SQLµÄÀ©Õ¹

MySQL·þÎñÆ÷°üº¬Ò»Ð©ÆäËûSQL DBMSÖв»¾ß±¸µÄÀ©Õ¹¡£×¢Ò⣬Èç¹ûʹÓÃÁËËüÃÇ£¬½«ÎÞ·¨°Ñ´úÂëÒÆÖ²µ½ÆäËûSQL·þÎñÆ÷¡£ÔÚijЩÇé¿öÏ£¬Äã¿ÉÒÔ±àд°üº¬MySQLÀ©Õ¹µÄ´úÂ룬µ«ÈÔ±£³ÖÆä¿ÉÒÆÖ²ÐÔ£¬·½·¨ÊÇÓÓ/*... */”×¢Ê͵ôÕâЩÀ©Õ¹¡£MySQL·þÎñÆ÷Äܹ»½âÎö²¢Ö´ÐÐ×¢ÊÍÖеĴúÂ룬¾ÍÏñ¶Ô´ýÆäËûMySQLÓï¾äÒ»Ñù£¬µ«ÆäËûSQL·þÎñÆ÷½«ºöÂÔ ......

MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà

Êý¾Ý¿â²Ù×÷ÀࣺDBCommon.class.php
//---------------------------------------------------------------------
// MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà
//
// ¿ª·¢×÷Õß: heiyeluren
// °æ±¾ÀúÊ·:
// 2006-09-20 »ù±¾µ¥Êý¾Ý¿â²Ù×÷¹¦ÄÜ, 25 ¸ö½Ó¿Ú
// 2007-07-30 Ö§³Öµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ