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); ÊÇÒª¿¼ÂÇ×Ö¶
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£ µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿ µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿ now() SQL code: sqlÀïÊÇ£º getdate() ÒýÓà now() ѧϰ SQL code: select now(); SQL code: TODAY() ? SQL code: select now(); /* ......
ÀûÓÃload data infileÃüÁîµ¼ÈëuserDesc.txtÊý¾Ý£¬Êý¾Ýµ¼ÈëºóËùÓеÄÖÐÎľÓȻȫÊÇÂÒÂ룬 mysql×Ö·û¼¯ÉèÖÃÈçÏ£º -> ; +--------------------------+----------------------------------- ......
linuxϵͳ ÔÀ´×Ô´ømysqlÒÑ¾Ð¶ÔØ ÐÂװа汾 °²×°Ê±Ìáʾ unpacking of archive failed on file usr/bin/ replace 4acebledle4d:cpio :read ÇëÎÊÊÇʲôÎÊÌâ ÒýÓà ÎļþÊÇÖ»¶ÁµÄ ¸ü¸ÄϸÃĿ¼ȨÏÞΪ ......