Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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);
ÊÇÒª¿¼ÂÇ×Ö¶


Ïà¹ØÎÊ´ð£º

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

mysqlÖÐÎÄÂÒÂë

ÀûÓÃload data infileÃüÁîµ¼ÈëuserDesc.txtÊý¾Ý£¬Êý¾Ýµ¼ÈëºóËùÓеÄÖÐÎľÓȻȫÊÇÂÒÂ룬
mysql×Ö·û¼¯ÉèÖÃÈçÏ£º
    -> ;
+--------------------------+----------------------------------- ......

mysql°²×°ÎÊÌâ unpacking of archive failed on¡£¡£

linuxϵͳ Ô­À´×Ô´ømysqlÒѾ­Ð¶ÔØ ÐÂװа汾 °²×°Ê±Ìáʾ unpacking of  archive  failed on file usr/bin/ replace 4acebledle4d:cpio :read ÇëÎÊÊÇʲôÎÊÌâ

ÒýÓÃ
ÎļþÊÇÖ»¶ÁµÄ ¸ü¸ÄϸÃĿ¼ȨÏÞΪ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ