Îå¸ö³£ÓÃMySQLͼÐλ¯¹ÜÀí¹¤¾ß
MySQLÊÇÒ»¸ö·Ç³£Á÷ÐеÄСÐ͹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬2008Äê1ÔÂ16ºÅ±»Sun¹«Ë¾ÊÕ¹º¡£Ä¿Ç°MySQL±»¹ã·ºµØÓ¦ÓÃÔÚInternetÉϵÄÖÐСÐÍÍøÕ¾ÖС£ÓÉÓÚÆäÌå»ýС¡¢Ëٶȿ졢×ÜÌåÓµÓгɱ¾µÍ£¬ÓÈÆäÊÇ¿ª·ÅÔ´ÂëÕâÒ»Ìص㣬Ðí¶àÖÐСÐÍÍøվΪÁ˽µµÍÍøÕ¾×ÜÌåÓµÓгɱ¾¶øÑ¡ÔñÁËMySQL×÷ΪÍøÕ¾Êý¾Ý¿â¡£
1¡¢phpMyAdmin£¨http://www.phpmyadmin.net/£©
phpMyAdminÊÇ×î³£ÓõÄMySQLά»¤¹¤¾ß£¬ÊÇÒ»¸öÓÃPHP¿ª·¢µÄ»ùÓÚWeb·½Ê½¼Ü¹¹ÔÚÍøÕ¾Ö÷»úÉϵÄMySQL¹ÜÀí¹¤¾ß£¬Ö§³ÖÖÐÎÄ£¬¹ÜÀíÊý¾Ý¿â·Ç³£·½±ã¡£²»×ãÖ®´¦ÔÚÓÚ¶Ô´óÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´²»·½±ã¡£
2¡¢MySQLDumper£¨http://www.mysqldumper.de/en/£©
MySQLDumperʹÓÃPHP¿ª·¢µÄMySQLÊý¾Ý¿â±¸·Ý»Ö¸´³ÌÐò£¬½â¾öÁËʹÓÃPHP½øÐдóÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄÎÊÌ⣬Êý°ÙÕ×µÄÊý¾Ý¿â¶¼¿ÉÒÔ·½±ãµÄ±¸·Ý»Ö¸´£¬²»Óõ£ÐÄÍøËÙÌ«Âýµ¼ÖÂÖмäÖжϵÄÎÊÌ⣬·Ç³£·½±ãÒ×Óá£Õâ¸öÈí¼þÊǵ¹úÈË¿ª·¢µÄ£¬»¹Ã»ÓÐÖÐÎÄÓïÑÔ°ü¡£
3¡¢Navicat£¨http://www.navicat.com/£©
NavicatÊÇÒ»¸ö×ÀÃæ°æMySQLÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢¹¤¾ß¡£ºÍ΢ÈíSQLServerµÄ¹ÜÀíÆ÷ºÜÏñ£¬Ò×ѧÒ×Óá£NavicatʹÓÃͼÐλ¯µÄÓû§½çÃ棬¿ÉÒÔÈÃÓû§Ê¹Óú͹ÜÀí¸üΪÇáËÉ¡£Ö§³ÖÖÐÎÄ£¬ÓÐÃâ·Ñ°æ±¾Ìṩ¡£
4¡¢MySQL GUI Tools£¨http://dev.mysql.com/downloads/gui-tools/£©
MySQL GUI ToolsÊÇMySQL¹Ù·½ÌṩµÄͼÐλ¯¹ÜÀí¹¤¾ß£¬¹¦ÄܺÜÇ¿´ó£¬ÖµµÃÍƼö£¬¿ÉϧµÄÊÇûÓÐÖÐÎĽçÃæ¡£
5¡¢MySQL ODBC Connector£¨http://dev.mysql.com/downloads/connector/odbc/£©
MySQL¹Ù·½ÌṩµÄODBC½Ó¿Ú³ÌÐò£¬ÏµÍ³°²×°ÁËÕâ¸ö³ÌÐòÖ®ºó£¬¾Í¿ÉÒÔͨ¹ýODBCÀ´·ÃÎÊMySQL£¬ÕâÑù¾Í¿ÉÒÔʵÏÖSQLServer¡¢AccessºÍMySQLÖ®¼äµÄÊý¾Ýת»»£¬»¹¿ÉÒÔÖ§³ÖASP·ÃÎÊMySQLÊý¾Ý¿â¡£
ÒÔÉϾÍÊÇÎÒ½éÉܵÄÎå¸ö³£ÓõÄMySQLά»¤¹ÜÀí¹¤¾ß£¬Èç¹ûÄãÖªµÀ¸üºÃµÄMySQL¹¤¾ß£¬ÇëÁôÑÔºÍÎÒÃÇ·ÖÏí¡£
Ïà¹ØÎĵµ£º
Ö®ËùÒÔдÕâƪ²©¿Í£¬ÊÇÒòΪǰ¼¸Ìì²ÅÅöµ½ÁËÕâôһ¸öÎÊÌ⣬ÒÔÇ°»¹²»ÖªµÀmysqlÓÐÕâôһ¸öÎÊÌâ¡£
ÎÒÃǵÄϵͳʹÓÃÁËstruts+hibernate£¬Êý¾Ý¿âʹÓõÄÊÇmysql£¬×Ö·û¼¯Í³Ò»Îªutf-8¡£
±¾À´ÒѾÍê³ÉÁË£¬µ«ÊÇϵͳʹÓõÄʱºò£¬·¢ÏÖ²é³öÀ´µÄÈËÃûûÓÐ˳Ðò£¬±¾À´ÒÔΪºÜ¼òµ¥£¬ÔÚ²éѯµÄʱºò£¬Ö¸¶¨°´ÕÕnameÅÅÐò¾Í¿ÉÒÔÁË£¬Æñ֪ʵ¼ÊÒ»×ö²Å·¢Ï ......
Êý¾Ý¿â²Ù×÷ÀࣺDBCommon.class.php
//---------------------------------------------------------------------
// MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà
//
// ¿ª·¢×÷Õß: heiyeluren
// °æ±¾ÀúÊ·:
// 2006-09-20 »ù±¾µ¥Êý¾Ý¿â²Ù×÷¹¦ÄÜ, 25 ¸ö½Ó¿Ú
// 2007-07-30 Ö§³Öµ ......
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°²×°³ÌÐòÒ»Ñù£¬Ê×ÏȳöÏÖµÄÊÇ°²×°Ïòµ¼»¶Ó½çÃæ
Ö ......
Èç¹ûÒ»¸öMyISAM±í°üº¬Èκοɱ䳤¶ÈÁУ¨VARCHAR, BLOB»òTEXTDynamic£©£¬»òÕßÈç¹ûÒ»¸ö±í±»ÓÃROW_FORMAT=DYNAMICÑ¡ÏîÀ´´´½¨£¬¶¯Ì¬´æ´¢¸ñʽ±»Ê¹Óá£
Õâ¸ö¸ñʽ¸üΪ¸´ÔÓÒ»µã£¬ÒòΪÿÐÐÓÐÒ»¸ö±íÃ÷ÐÐÓж೤µÄÍ·¡£µ±Ò»¸ö¼Ç¼ÒòΪ¸üеĽá¹û±»±äµÃ¸ü³¤£¬¸Ã¼Ç¼Ҳ¿ÉÒÔÔÚ³¬¹ýÒ»¸öλÖô¦½áÊø¡£
Äã¿ÉÒÔʹÓÃOPTIMIZE TAB ......
¶ÔÓÚÿ¸öÀàÐÍÓµÓеÄÖµ·¶Î§ÒÔ¼°²¢ÇÒÖ¸¶¨ÈÕÆÚºÎʱ¼äÖµµÄÓÐЧ¸ñʽµÄÃèÊö¼û7.3.6 ÈÕÆÚºÍʱ¼äÀàÐÍ¡£
ÕâÀïÊÇÒ»¸öʹÓÃÈÕÆÚº¯ÊýµÄÀý×Ó¡£ÏÂÃæµÄ²éѯѡÔñÁËËùÓмǼ£¬Æädate_colµÄÖµÊÇÔÚ×îºó30ÌìÒÔÄÚ£º
mysql> SELECT something from table
WHERE TO_DAYS(NOW())&nbs ......