MySQL¶àÏß³Ì
ÔÚ½øÐÐÊý¾Ý¿â¶ÁдµÄʱºò£¬Ò»°ãÇé¿ö϶¼Êǵ¥Ï̵߳쬵«ÊÇÈçºÎÔÚ²Ù×÷µÄʱºòҲʹÓöàÏß³ÌÄØ£¿Ê¹ÓöàḬ̈߳²È«Â𣿶àÏß³ÌÊÇÈçºÎ±£Ö¤°²È«µÄÄØ£¿Èç¹ûÓдúÂëµÄ»°£¬Ìù³öÀÛ»òÕß°Ñ´úÂë¹²Ïí¸øÎÒѧϰѧϰ¡£¡£¡£¶àл£¡
ÄãÊÇÖ¸ÍâÃæ³ÌÐòÓöàÏ߳̽øÐÐÊý¾Ý¿â¶Áд£¿ Èç¹ûÊÇÕâÑùµÄ»°£¬ÄãÖ»Òª±£Ö¤ÄãÍâÃæ³ÌÐò¶àÏ̵߳¥¶ÀÁ¬½ÓÊý¾Ý¿â¾ÍÐÐÁË£¬ÖÁÓÚºǫ́Êý¾Ý¿âµÄ¶à¸ö¶Áдͬʱ´¦ÀíµÄÎÊÌ⣬Êý¾Ý¿âÄÚ²¿ÓÐËø»úÖÆ×Ô¶¯¹ÜÀíµÄ¡£ Ò»¸öÁ¬½Ó£¬ÍâÃæ³ÌÐò¶àỊ̈߳¬ÎÒÏëÒªÊý¾Ý¿â·½ÃæÒ²ÊǶàÏ̡߳£ ÄÇÓ¦¸ÃÀàËÆmysql cluster ºÍmaster and slave °É ÒýÓà һ¸öÁ¬½Ó£¬ÍâÃæ³ÌÐò¶àỊ̈߳¬ÎÒÏëÒªÊý¾Ý¿â·½ÃæÒ²ÊǶàÏ̡߳£ ÄÇÄãÿ¸öÏ̵߳¥¶ÀÁ¬Êý¾Ý¿â²ÅÐС£ ÄѵÀMySQLÔÚÖ´ÐÐsqlÓï¾äµÄʱºòÖ»ÄÜ¿ªÒ»¸öÏß³ÌÖ´ÐÐÖðÌõ¶à¸ösqlÓï¾äÂ𣿠²»¿ÉÒÔ¿ª¶à¸öÏß³ÌͬʱִÐÐsqlÓï¾äÂð£¿
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£ µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿ µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿ ÄãÊÇÈçºÎɾ³ýµÄ£¿ ÓÐʲôÌáʾ£¿ ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï. ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî SQL code: update ±í set introtxt=left(`fulltext`,300); ¶¥£¬Ñ§Ï° SQL code: ......
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿ 1 nike 100 ϵͳʱ¼ä 2 nike 300 &n ......