MySQL 5.1.45 GA ·¢²¼
¸Ã°æ±¾Éý¼¶ InnoDB ²å¼þµ½ 1.0.6 °æ±¾£¬Ä¿Ç° 1.0.6 °æ±¾µÄ InnoDB µÄÖÊÁ¿²î²»¶àÊÇ RC ºòÑ¡·¢Ðм¶±ðµÄ¡£ÁíÍâһЩÃüÁîÐй¤¾ß¸÷×ÔÔö¼ÓÁËһЩ²ÎÊýÑ¡ÏÏêÇéÇë¿´ÕâÀï¡£MySQL£¨·¢Òô£º[ˌmaɪ ɛs kjuː ˈɛl]£¬µ«Ò²¾³£¶Á×÷My- SEQuel£©ÊÇÒ»¸ö¿ª·ÅÔ´ÂëµÄ¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ£¬¿ª·¢ÕßΪÈðµäMySQL AB¹«Ë¾£¬ÏÖΪSun¹«Ë¾µÄÒ»²¿·Ö¡£
2009ÄêOracleÐû²¼ÊÕ¹ºSun¹«Ë¾£¬Òò´ËMySQL¿ÉÄܳÉΪOracleÆìϲúÆ·¡£MySQLÓÉÓÚÐÔÄܸߡ¢³É ±¾µÍ¡¢¿É¿¿ÐԺã¬ÒѾ³ÉΪ×îÁ÷ÐеĿªÔ´Êý¾Ý¿â£¬±»¹ã·ºµØÓ¦ÓÃÔÚInternetÉϵÄÖÐСÐÍÍøÕ¾ÖС£Ëæ×ÅMySQLµÄ²»¶Ï³ÉÊ죬ËüÒ²Öð½¥ÓÃÓÚ¸ü¶à´ó¹æÄ£ÍøÕ¾ ºÍÓ¦Ó㬱ÈÈçά»ù°Ù¿Æ¡¢GoogleºÍFacebook¡£·Ç³£Á÷ÐеĿªÔ´Èí¼þ×éºÏLAMPÖеÄM¾ÍÊÇÖ¸ MySQL¡£
Ñà¶¼¹Ç¿ÆÒ½ÔºÕ¾³¤Ìṩ
Ïà¹ØÎĵµ£º
ÕâÀïÊÇÒ»¸öʹÓÃÈÕÆÚº¯ÊýµÄÀý×Ó¡£ÏÂÃæµÄ²éѯѡÔñËùÓÐ date_col ÖµÔÚ×îºó 30 ÌìÄڵļǼ¡£
mysql> SELECT something from tbl_name
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30;
DAYOFWEEK(date) ·µ»Ø date µÄÐÇÆÚË÷Òý(1 = Sunday, 2 = Monday, ... 7 = Saturday)¡£Ë÷ÒýÖµ·ûºÏ ODBC µÄ±ê×¼¡£
mysq ......
µ±Ì¸µ½¿ªÔ´Êý¾Ý¿âʱ£¬MySQL»ñ
µÃÁËÒµ½ç´ó²¿·ÖµÄ×¢ÒâÁ¦£¬MySQLÊÇÒ»¸öÒ×ÓÚʹÓõÄÊý¾Ý¿â£¬Í¬Ê±ÓÐÐí¶à¿ªÔ´µÄWebÓ¦ÓóÌÐò¶¼ÊÇÖ±½ÓÔÚËüÉÏÃæ¿ª·¢µÄ¡£
ÁíÍâÒ»ÖÖÖ÷ÒªµÄ¿ªÔ´Êý¾Ý¿âÊÇPostgreSQL£¬ËäÈ»ËüÒ²ÊÇÖÚËùÖÜÖªµÄ£¬µ«ÊÇȴûÓлñµÃÏñMySQLËùµÃµ½µÄÈϿɡ£ÕâÊǺܲ»Ðҵģ¬ÒòΪÔÚÕâÁ½Õß
ÖУ¬Ïà±ÈMySQL£¬PostgreSQLÄÜÌṩ¸ü¼Ó°²È ......
µ±ÄãÁ¬½ÓÒ»¸öMySQL·þÎñÆ÷ʱ£¬Äãͨ³£Ó¦¸ÃʹÓÃÒ»¸ö¿ÚÁî¡£¿ÚÁî²»ÒÔÃ÷ÎÄÔÚÁ¬½ÓÉÏ´«Êä¡£
ËùÓÐÆäËûÐÅÏ¢×÷ΪÄܱ»ËùÓÐÈ˶Á¶®µÄÎı¾±»´«Êä¡£Èç¹ûÄãµ£ÐÄÕâ¸ö£¬Äã¿ÉʹÓÃѹËõÐÒé(MySQL3.22ºÍÒÔÉϰ汾)ʹÊÂÇé±äµÃ¸üÄÑ¡£ÉõÖÁΪÁËʹһÇиü°²È«£¬ÄãÓ¦¸Ã°²×°ssh£¨¼ûhttp://www.cs.hut.fi/ssh)¡£ÓÃËû£¬ÄãÄÜÔÚÒ»¸öMySQL·þÎñÆ÷ºÍÒ»¸öMySQL¿Í» ......
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£±¾ÎÄÖ÷Òª¶ÔMyISAM±í×ö±¸·Ý»Ö¸´¡£
±¸·Ý²ßÂÔÒ»£ºÖ±½Ó¿½±´Êý¾Ý¿âÎļþ£¨²»ÍƼö£©
±¸·Ý²ßÂÔ¶þ£ºÊ¹ÓÃmysqlhotcopy±¸·ÝÊý¾Ý¿â£¨ÍêÈ«±¸·Ý£¬ÊʺÏСÐÍÊý¾Ý¿â±¸·Ý£©
±¸·Ý²ßÂÔ ......
ΪÁËÈÃÓû§²»ÐèÒª×Ô¼ºÔËÐÐmysql°²×°³ÌÐò°²×°mysqlÊý¾Ý¿â£¬Èí¼þ·¢²¼Ê±ÐèÒª´ò°üÃâ°²×°°æ±¾µÄmysql¡£´Ómysql¹ÙÍøÉÏÖ±½ÓÏÂÔØµÄÃâ°²×°°æ±¾ÐèÒª¸÷ÖÖÅäÖã¬Èç¹ûÅäÖò»ºÃ£¬ºÜÈÝÒײúÉú¸÷ÖÖ¸÷ÑùµÄÎÊÌâ¡£ÓÈÆäÊÇ´íÎóÂëΪ1067µÄÎÊÌ⣬ÎÒÊÔÑéÁËÍøÉϵĺܶ෽·¨¶¼Ã»Æð×÷Óã¬×îºóÏëÁËÒ»¸ö×î¼òµ¥µÄ·½·¨£º
£¨1£©Ê×ÏÈʹÓð² ......