MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï. ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁîSQL code: update ±í set introtxt=left(`fulltext`,300);
¶¥£¬Ñ§Ï° SQL code: UPDATE TB SET introtxt=SUBSTR(fulltext,1,300) WHERE LENGTH(fulltext)>=300
³¤¶ÈСÓÚ300µÄ²»´¦Àí SQL code: UPDATE TB SET introtxt=CASE WHEN LENGTH(fulltext)>=300 THEN SUBSTR(fulltext,1,300) ELSE fulltext END