mysqlµÄ¼¸¸öСÎÊÌâ
1¡¢ÎªÊ²Ã´ÓÃmediumint(8)¶ø²»ÓÃint(11)£¬ÎÒ¿´ºÜ¶àÂÛ̳µÄÌù×Ó±íÉè¼Æ¶¼ÓÃmediumint(8) unsigned£¬×î´óÒ²¾ÍÊÇ16777215£¬Ò²¾ÍÊÇ1ǧ¶àÍòÌõ¼Ç¼¡£´óÐÍÂÛ̳¿ÉÄܲ»Ö¹ÕâôЩÊý¾Ý°É 2¡¢µ±Êý¾Ý´ïµ½1ǧ¶àÍòÌõʱËÙ¶È»áÃ÷ÏÔ±äÂýÂð£¿
2¡¢µ±Êý¾Ý´ïµ½1ǧ¶àÍòÌõʱËÙ¶È»áÃ÷ÏÔ±äÂýÂð£¿Õâ¸öÒª¿´¾ßÌåµÄ±íÉè¼ÆºÍÓ¦ÓóÌÐò¡£ Èç¹ûʲôÓÅ»¯¶¼Ã»ÓУ¬µ±È»Ò»¸ö±íÖмǼԽ¶à£¬²éѯËÙ¶ÈÔ½Âý¡£ Ö÷Òª¿´Êµ¼ÊÐèÒª£¬Èç¹ûÊý¾ÝÁ¿´ó¾Í°ÑÄÚÈݱä´óµã¡£ ÔÚÖйú£¬Ò»°ãÓ¦ÓúÜÉÙ»á³öÏÖǧÍò¼¶±ðµÄ£»Èç¹ûÿ¸öϵͳ¶¼Õâô¶àÊý¾Ý£¬ÖйúIT¾Í²»ÓÃÕâÑù²Òµ¾ÓªÁË¡£ mediumint(8)ºÍint(11)³ýÁËÕ¼ÓÃ×Ö½ÚÊý²»Ò»Ñù£¬²»Í¬µÄ×Ö¶ÎÉè¼Æ¶Ô²éѯËÙ¶ÈÓÐÓ°ÏìÂð¡£ÒýÓà mediumint(8)ºÍint(11)³ýÁËÕ¼ÓÃ×Ö½ÚÊý²»Ò»Ñù£¬²»Í¬µÄ×Ö¶ÎÉè¼Æ¶Ô²éѯËÙ¶ÈÓÐÓ°ÏìÂð¡£ Õâ×ãÒÔ¾ö¶¨ËüÕ¼ÓÃÄÚ´æµÄ¶àÉÙ£¬ ͨË×µÄ˵ռÓÃÄÚ´æÉٵĿÉÒÔÔÚcacheÖж໺´æ¼¸ÐÐÊý¾Ý +------------+------+ |date|ml| +------------+------+ |2010-01-06|55| |2010-01-06|85| |2010-01-06|50| |2010-01-06|50| |2010-01-07|40| |2010-01-07|50| |2010-01-07|25| |2010-01-07|95| |2010-01-07|40| |2010-01-07|40| |2010-01-08|75| |2010-01-08|100| +------------+------+ C/C++ code: +------------+------+ |date|ml| +------------+--
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ ¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ ÓóÌÐòÔ ......