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

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¡£
Ñà¶¼¹Ç¿ÆÒ½ÔºÕ¾³¤Ìṩ


Ïà¹ØÎĵµ£º

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 ......

ʹÓÃrootÓû§ÔËÐÐMYSQLµÄ°²È«Òþ»¼

µ±ÄãÁ¬½ÓÒ»¸öMySQL·þÎñÆ÷ʱ£¬Äãͨ³£Ó¦¸ÃʹÓÃÒ»¸ö¿ÚÁî¡£¿ÚÁî²»ÒÔÃ÷ÎÄÔÚÁ¬½ÓÉÏ´«Êä¡£
ËùÓÐÆäËûÐÅÏ¢×÷ΪÄܱ»ËùÓÐÈ˶Á¶®µÄÎı¾±»´«Êä¡£Èç¹ûÄãµ£ÐÄÕâ¸ö£¬Äã¿ÉʹÓÃѹËõЭÒé(MySQL3.22ºÍÒÔÉϰ汾)ʹÊÂÇé±äµÃ¸üÄÑ¡£ÉõÖÁΪÁËʹһÇиü°²È«£¬ÄãÓ¦¸Ã°²×°ssh£¨¼ûhttp://www.cs.hut.fi/ssh)¡£ÓÃËû£¬ÄãÄÜÔÚÒ»¸öMySQL·þÎñÆ÷ºÍÒ»¸öMySQL¿Í» ......

¹ØÓÚMySQL ORDER BY

ÓÉÓÚϵͳÐèÒª£¬Ð´ÁËÒ»¸öORDER BY µÄSQL²éѯÓï¾ä½øÐÐ×Ö¶ÎÅÅÐò£¬²éѯ½á¹ûûÓнøÐÐÅÅÐò£¬SQLÓï·¨ÕýÈ·£»
ÓÚÊÇ£¬½øÈëMySQL¿ØÖÆÌ¨£¬Ö´ÐÐSQLÓï¾ä£¬Ã»Óб¨´í£¬µ«ÊǾÍÊÇûÓÐÅÅÐò£»
¾­¹ý²éÕÒ·¢ÏÖ£¬ÔÚд ORDER BY ' time' DESC  Óï¾äÖУ¬Ê¹ÓÃÁË“ ' ”·ûºÅ£¬µ¼ÖÂMySQLÎÞ·¨Õý³£½âÎö£¬È¥µôÅÅÐòÕý³££»
»òÕß¿ÉÒÔÓà &ldqu ......

Hibernate + MYSQL½áºÏ´æ´¢ Blob ºÍ ClobÄÚÈÝ

      ½ñÌ죬ÕÛÌÚÁËÒ»¸öÏÂÎ磬ÖÕÓÚ½â¾öÁËHibernate ´æ´¢Blob×Ö¶Îʱ£¬Êý¾ÝÁ¿·Ç³£´óʱ×ÜÊDZ¨ can not update jdbc batchµÄ´íÎóÁË£¬Ô­À´ÊÇMySQLÖÐûÓÐÉ趨×î´óÔÊÐíÖµËùÖ£¬ÎÒ»¹ÒÔΪÊÇHibernate²Ù×÷²»·ûºÏ±ê×¼²ÅÕâÑù¡£¡£¡£ºÇºÇ£¬ÔÚMysql 5.1ÖеÄmy.iniÅäÖÃÎļþÖмÓÈëÈçÏÂÉèÖãº
[MYSQL]
max_allowed ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ