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

¹ØÓÚmysqlµÄinsertÐÔÄÜ

²É¼¯ÏµÍ³£¬Ïë°ÑÓб仯µÄÊý¾Ý²åÈëÊý¾Ý¿â¡£

´ó¸Å1ÃëÖÓÓб仯µÄÁ¿2000¸ö×óÓÒ¡£ÊýÖµÊÇfloatÐÍ£¬Ò²¾ÍÊÇ8000¸ö×Ö½Ú¡£

ÏÖÔÚÓÐÁ½ÖÖ·½·¨£º
1 ÅúÁ¿ insert£¬Ã¿¸ö±ä»¯±£´æ1Ìõ¼Ç¼£¨²éѯ·½±ã£©£¬insert into values£¨£©£¨£©Ò»¹²2000¸ö£¬ ºÄʱ120ms¡£
2 °ÑÒ»¸ö¶þ½øÖÆÊý×éÖ±½Ó±£´æµ½longblob ×ֶΣ¬·¢ÏÖ380000¸ö×Ö½Ú£¬Ò²Ö»Òª10ms¡£

²î¾àÕæµÄÕâô´ó£¿£¿£¿£¿

µÚ2ÖÖ·½·¨ÓÖ¿ÉÒÔÓÐ2ÖÖ
1 Ö»±£´æ±ä»¯£¬¶þ½øÖƸñʽ¡¾±ä»¯Á¿ID,±ä»¯Á¿Öµ¡¿£¬£¬£¨ÕâÑù±£´æµÄÊý¾ÝÁ¿Ð¡ £¬µ«ÊDzéѯºÜÀ§ÄÑ£¬Òª½âÎö¶þ½øÖÆ £©
2 Ö»Òª¸ÃÃëÓб仯£¬¾Í¼Ç¼ËùÓеÄÁ¿£¬£¨ÕâÑù²éѯ±È½Ï¼òµ¥£¬Ö±½ÓËãÐèÒªµÄÁ¿µÄÆ«ÒÆÁ¿¾Í¿ÉÒÔ£©

Âé·³ÄÄλ¸ßÊÖ°ï·ÖÎöһϡ£
ÓÐЩÏó¹¤ÒµÏµÍ³µÄÉè¼Æ¡£

Ò»°ãÊÇÉÏλ»ú»á°´µÚ¶þÖÖ·½·¨ÖеĵڶþÖÖ¸ñʽ½øÐС£Óб仯ʱ¼Ç¼ËùÓеÄÁ¿£¬Ö±½Ó°ÑÏÂÃæµÄÐÅÏ¢£¨±¾ÉíÒѾ­ÔÚÄÚ´æµÄ¿éÖУ©È«²¿Ð´Èëµ½´ÅÅÌ»òÊý¾Ý¿â¡£

¶øºǫ́Ö÷»úÔò¸ºÔðÂýÂýµÄ´¦Àí£¬ÒÔ¹©±¨±í·ÖÎöʹÓá£

ÒýÓÃ
ÓÐЩÏó¹¤ÒµÏµÍ³µÄÉè¼Æ¡£

Ò»°ãÊÇÉÏλ»ú»á°´µÚ¶þÖÖ·½·¨ÖеĵڶþÖÖ¸ñʽ½øÐС£Óб仯ʱ¼Ç¼ËùÓеÄÁ¿£¬Ö±½Ó°ÑÏÂÃæµÄÐÅÏ¢£¨±¾ÉíÒѾ­ÔÚÄÚ´æµÄ¿éÖУ©È«²¿Ð´Èëµ½´ÅÅÌ»òÊý¾Ý¿â¡£

¶øºǫ́Ö÷»úÔò¸ºÔðÂýÂýµÄ´¦Àí£¬ÒÔ¹©±¨±í·ÖÎöʹÓá£


лл£¬¾ÍÊǹ¤ÒµÏµÍ³ÖÐÉÏλ»úµÄ´æ´¢£¬ÕýÏë°´µÚ¶þÖÖ·½Ê½×ö£¬Ì«¸ÐлÁË¡£

ûÓÐÆäËûר¼ÒÌṩһµã²Î¿¼Òâ¼ûÂ𣿣¿£º£©

Äã¿ÉÒÔ½«ÄãÁ½ÖÖ·½°¸µÄÖ´ÐÐʱ¼ä±È½ÏÒ»ÏÂ

µÚÒ»ÖÖ¼ÓÉϽâÎö¶þ½øÖƵÄʱ¼ä¿´¿´ÄǸöÖ´ÐÐЧÂʸß


ÒýÓÃ
Äã¿ÉÒÔ½«ÄãÁ½ÖÖ·


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

mysql µ¼ÖÂËÀ»ú

»·¾³£º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 ......

mysql like ÎÊÌâ

select * from table where '123456789' like '%'+×ֶαí+'%'


Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......

mysqlÖÐÔõô²é¿´Ä£Ê½Ä¬ÈϵÄËÑË÷·¾¶search_path°¡

ÎÒÔÚÊéÉÏ¿´µ½ËµÃ¿Ò»¸ö±í¶¼ÊôÓÚijһ¸öģʽ£¬Èç¹ûҪΪ±íÖ¸¶¨Ä£Ê½£¬ÓÐÈýÖÖ·½·¨£º
1£©
ÔÚ´´½¨±íʱÏÔʽµÄ¸ø³öģʽÃû£¬±ÈÈçcreate table "xxx".sno(......);
2£©
ÔÚ´´½¨Ä£Ê½µÄʱºòͬʱ´´½¨±í
3) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ