mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓᣠÊý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐпոñÇø·Ö£¬È»ºóÓÃLIKE²éÕÒ£¬µ«ÕâÑù×ÓЧÂʺܲÇÒ²éÕҵĽá¹ûÒ²²»´ó׼ȷ¡£ ²»Öª»¹ÓÐûÓÐÆäËüµÄ·½·¨£¿ÆÚ´ý¸ßÈËÖ¸µã¡£ ÏñÌÔ±¦²»ÖªÊÇÓÃʲô·½·¨£¬ËüÄÇô´óµÄÊý¾ÝÁ¿¾¹È»ÄÜÕâô¿ìÇҺܾ«×¼£¬ÓÐÈËÖªµÀÂð£¿
lucene ÖÐÎÄ·Ö´Ê ´´½¨È«ÎÄË÷Òý ±êÌâµ¥¶À½¨Ò»Õűí ËÑË÷±êÌâ±í лл. ÍüÁË˵£¬ÎÒÊÇʹÓÃPHP+MYSQLµÄ£¬Ï£ÍûÓоßÌåµãµÄ˵Ã÷ ûÓÐʲôºÃ°ì·¨¡£ ·½·¨Ò»£¬Ê¹ÓÃÈ«ÎÄËÑË÷¡£ ·½·¨¶þ£¬ÔÙ½¨Ò»¸ö±í£¬ µ«Êý¾ÝÁ¿´óµÄʱºò²¢²»ÍƼö¡£ ¸Õ¿´ÁËDZµÄËÑË÷£¬ËüËÆºõ¾ÍÊÇACMAINËù˵µÄ½¨¶àÒ»¸ö±í£¬ºÜÂé·³ ²»ÖªÈ«ÎÄËÑË÷ÓÃʲô·½·¨ÄØ£¿innodbËÆºõ²¢²»Ö§³Ö ͬÎÊ¡£ ÈçºÎʵÏÖ¸ßЧµÄphp+mysqlµÄÈ«ÎÄËÑË÷ È«ÎÄË÷ÒýĿǰֻ¶ÔmyisamÒýÇæÓÐЧŶÒýÓà ȫÎÄË÷ÒýĿǰֻ¶ÔmyisamÒýÇæÓÐЧŶ £¿£¿ ÕæµÄ¡£¡£ ¹ÑÎÅÁË¡£ ʹÓ÷ִÊÊÇ×îΪºÃµÄ¡£¡£ likeÈ«ÎÄɨÃèû°ì·¨£¬ÊÇ·ñ¿ÉÒÔÓÐÆäËûwhere¼õÉÙÃüÖÐÂÊ¡£ select * from (select * from tb1 where a between A1 and A2)t where t.b like '%str%'; ÒýÇæ»¹ÊÇ»» MyISAM°É ¶¥ ¿´À´Ò²Óв»ÉÙÈË´æÔÚÕâÑùµÄÀ§»ó£¬ÄѵÀʹÓÃinnodbµÄ¾Íû·¨½øÐÐÈ«ÎÄË÷ÒýÁËÂ𣿠Äã¿ÉÒ԰ѱêÌ⽨һ¸ö±í£¬È»ºóÓÃн¨µÄÕâ¸ö±íÓëÈ«ÎÄµÄ±í½¨ÊÓͼ£¬ËÑË÷µÄʱºòÖ±½ÓÔÚÊÓͼÀïÃæËÑË÷£¬Ê¡Á˺öàËÑË÷Óï¾ä£¬ºÜ·½±ãµÄ£¡ ¹Ø×¢¡£Ò²Óö
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÇëÎÊһϣ¬mysqlµÄsequenceÊÇ×Ô¶¯µÝÔöµÄ£¬²»ÐèÒª½øÐвÙ×÷¡£ ÄÇÎÒÔÚ²åÈëÒ»ÌõÖ÷¼Ç¼µÄʱºò£¬Í¬Ê±Òª¸øÕâ¸öÖ÷¼üµÄÆäËû±í½øÐвåÈëÊý¾Ý¡£Õâʱºò£¬ÎÒ¸ù±¾È¡²»µ½Õâ¸öµÝÔöµÄsequence°¢¡£¡£ Õâ¸öÎÊÌâÔõô½â¾ö°¢¡£¡£
......
ÎÒÔÚ°²×°ÂÛ̳µÄʱºò£¬Ð½¨ÁËÒ»¸öMYSQLÓû§£¬È¨ÏÞÊÇALL£¨grant all ¡¡£©£¬ÏÖÔÚÂÛ̳°²×°ºÃÁË£¬ÎÒÏëÈÃÕâ¸öÓû§Ö»ÄܲÙ×÷ÌØ¶¨Êý¾Ý¿â£¨·ÃÎʺÍÐ޸쬰üÀ¨´´½¨É¾³ý±í£¬×îºÃ²»ÄÜɾ³ýÊý¾Ý¿â£¬µ«×ö²»µ½¾ÍËãÁË£©£¬ÀýÈçtestÊý¾Ý ......
ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£ ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ Í¬Ê±Óû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý ......