¹ØÓÚmysqlµÄinsertÐÔÄÜ
²É¼¯ÏµÍ³£¬Ïë°ÑÓб仯µÄÊý¾Ý²åÈëÊý¾Ý¿â¡£ ´ó¸Å1ÃëÖÓÓб仯µÄÁ¿2000¸ö×óÓÒ¡£ÊýÖµÊÇfloatÐÍ£¬Ò²¾ÍÊÇ8000¸ö×Ö½Ú¡£ ÏÖÔÚÓÐÁ½ÖÖ·½·¨£º 1 ÅúÁ¿ insert£¬Ã¿¸ö±ä»¯±£´æ1Ìõ¼Ç¼£¨²éѯ·½±ã£©£¬insert into values£¨£©£¨£©Ò»¹²2000¸ö£¬ ºÄʱ120ms¡£ 2 °ÑÒ»¸ö¶þ½øÖÆÊý×éÖ±½Ó±£´æµ½longblob ×ֶΣ¬·¢ÏÖ380000¸ö×Ö½Ú£¬Ò²Ö»Òª10ms¡£ ²î¾àÕæµÄÕâô´ó£¿£¿£¿£¿ µÚ2ÖÖ·½·¨ÓÖ¿ÉÒÔÓÐ2ÖÖ 1 Ö»±£´æ±ä»¯£¬¶þ½øÖƸñʽ¡¾±ä»¯Á¿ID,±ä»¯Á¿Öµ¡¿£¬£¬£¨ÕâÑù±£´æµÄÊý¾ÝÁ¿Ð¡ £¬µ«ÊDzéѯºÜÀ§ÄÑ£¬Òª½âÎö¶þ½øÖÆ £© 2 Ö»Òª¸ÃÃëÓб仯£¬¾Í¼Ç¼ËùÓеÄÁ¿£¬£¨ÕâÑù²éѯ±È½Ï¼òµ¥£¬Ö±½ÓËãÐèÒªµÄÁ¿µÄÆ«ÒÆÁ¿¾Í¿ÉÒÔ£© Âé·³ÄÄλ¸ßÊÖ°ï·ÖÎöһϡ£
ÓÐЩÏó¹¤ÒµÏµÍ³µÄÉè¼Æ¡£ Ò»°ãÊÇÉÏλ»ú»á°´µÚ¶þÖÖ·½·¨ÖеĵڶþÖÖ¸ñʽ½øÐС£Óб仯ʱ¼Ç¼ËùÓеÄÁ¿£¬Ö±½Ó°ÑÏÂÃæµÄÐÅÏ¢£¨±¾ÉíÒѾÔÚÄÚ´æµÄ¿éÖУ©È«²¿Ð´Èëµ½´ÅÅÌ»òÊý¾Ý¿â¡£ ¶øºǫ́Ö÷»úÔò¸ºÔðÂýÂýµÄ´¦Àí£¬ÒÔ¹©±¨±í·ÖÎöʹÓá£ÒýÓà ÓÐЩÏó¹¤ÒµÏµÍ³µÄÉè¼Æ¡£ Ò»°ãÊÇÉÏλ»ú»á°´µÚ¶þÖÖ·½·¨ÖеĵڶþÖÖ¸ñʽ½øÐС£Óб仯ʱ¼Ç¼ËùÓеÄÁ¿£¬Ö±½Ó°ÑÏÂÃæµÄÐÅÏ¢£¨±¾ÉíÒѾÔÚÄÚ´æµÄ¿éÖУ©È«²¿Ð´Èëµ½´ÅÅÌ»òÊý¾Ý¿â¡£ ¶øºǫ́Ö÷»úÔò¸ºÔðÂýÂýµÄ´¦Àí£¬ÒÔ¹©±¨±í·ÖÎöʹÓᣠлл£¬¾ÍÊǹ¤ÒµÏµÍ³ÖÐÉÏλ»úµÄ´æ´¢£¬ÕýÏë°´µÚ¶þÖÖ·½Ê½×ö£¬Ì«¸ÐлÁË¡£ ûÓÐÆäËûר¼ÒÌṩһµã²Î¿¼Òâ¼ûÂ𣿣¿£º£© Äã¿ÉÒÔ½«ÄãÁ½ÖÖ·½°¸µÄÖ´ÐÐʱ¼ä±È½ÏһϠµÚÒ»ÖÖ¼ÓÉϽâÎö¶þ½øÖƵÄʱ¼ä¿´¿´ÄǸöÖ´ÐÐЧÂÊ¸ß ÒýÓà Äã¿ÉÒÔ½«ÄãÁ½ÖÖ·
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£ µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿ µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡ Çë¸÷λ¸øÒÔÌáʾ¡£ ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É 1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺 <?php $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error()); & ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ ......
»·¾³£ºwin2003 apache2 resin3 php5 mysql5 mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£ InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_log ......