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

MYSQL Êý¾Ý½ØÈ¡

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

fulltext³¤¶ÈСÓÚ300ʱ£¬¾ÍÈ¡fulltextµÄÖµ

´ÓÂ¥Ö÷µÄÐèÇó¿´À´£¬¹À¼ÆÂ§Ö÷µÄÁв»ÊÇcharÀàÐ͵ģ¬Ó¦¸ÃÊÇvarchar»òtextÀàÐ͵ģ¬ËùÒÔ£¬Ö±½ÓÕâÑù¾Í¿ÉÒÔ£º

ÒýÓÃ
SQL codeupdate ±íset introtxt=left(`fulltext`,300);


ÒýÓÃMYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï.


½ö´ÓÕâ¸ö˵Ã÷ÉÏÀ´¿´¡£Ò»Â¥µÄ update ±í set introtxt=left(`fulltext`,300); Ó¦¸Ã¾Í¿ÉÒÔÁË¡£

Ê÷¸ç ºÜÑϽ÷£¡ÏòÊ÷¸çѧϰ£¡

update ±í set introtxt=left(`fulltext`,300);
ÊÇÒª¿¼ÂÇ×Ö¶


Ïà¹ØÎÊ´ð£º

jsp±¸·ÝmysqlÖ»ÓпÕÎļþ

ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......

Mysql Êý¾Ý¿âɾ³ý²»ÁËÔõô°ì

ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿


ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©

......

¹ØÓÚTXTÎļþµ¼ÈëMYSQLÎÊÌâ

Ö÷ÒªÇé¿öÈçÏ£º
ÏÖÓÐÒ»Îı¾Êý¾ÝÎļþ£¬ÀïÃæµÄÊý¾ÝÈçÏ£º

abc  123 
def  223  2  wwww
uuu  456  5  xxx
¡­¡­

Êý¾ÝÓм¸wÌõ Ò»ÐÐ×î¶à4ÁÐ µ« ......

jsp+MySQL×¢²áÒ³Ãæ

<form action="" method="post" onSubmit="return aa();" >
<body onload="setup()">
<div align="center" class="STYLE1"&g ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ