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

mysqlÊý¾Ý²éѯ ÇëÖú £º£º

ÐèÇ󣺲éѯһ¸ömysqlÊý¾Ý¿âÀïµÄ±í£¨products ×ֶΣºid(int),name(varchar),miaoshu(varchar)£©

ÏëÔÚÒ³ÃæÖÐÏÔʾmiaoshuÕâÒ»ÁÐ µ«ÊÇÕâÒ»ÁеÄ×Ö·ûºÜ¶à ÏëÏÞÖÆÏÔʾµÄ×Ö·û¸öÊý ÄÇЩ¶à³öÀ´µÄÓÃ"²é¿´¸ü¶à¡£¡£¡£"µÄÁ´½Ó´úÌæ

£¨µã»÷Õâ¸öÁ´½Ó Ìø×ªµ½ÁíÒ»¸öÒ³Ãæ ÏÔʾËùÓеÄÏêϸÐÅÏ¢£©
Ôõôд²éѯÓï¾äÀ´ÏÞÖÆ×Ö·ûµÄ¸öÊý ÄØ£¿ÊµÏÖÕâÒ»¹¦ÄÜÄØ£¿


LEFT(miaoshu,20)

SELECT id,IF(CHAR_LENGTH(content)>80,CONCAT(LEFT(content,80),\'²é¿´¸ü¶à...\'),content) AS content from test

phpÏÈÖ´ÐР substr($miaoshu,0,100) Ö»ÏÔʾ´Ó0µ½100
ÕâÑù±ÈÔÚ²éѯÓï¾äÖкõöࡣ²»È»ÄãÏëÈ«²¿¿´µ½µÄʱºò¾ÍûÕÞÁË¡£


ÒýÓÃ
×îºÃÊÇÏÈÈ«²¿È¡³ö¡£×îºóÓÃphpµÄsubstrÈ¥½ØÈ¡È»ºóÏÔʾÔÚÒ³ÃæÖС£
Ò²²»±ØÒ»¶¨ÒªÒ»¸ösql¾Í¸ã¶¨°¡

ÕâÑù  ºÜºÏÀí


Ïà¹ØÎÊ´ð£º

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......

ÐèÒªÊÓÆµ½Ì³ÌµÄÐÂÊÖ½ø php + mysql + apache ÅäÖÃ

Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´


......

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

MySQL´íÎó - PHP / »ù´¡±à³Ì

ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿

ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ

¿ÉÒÔÓÃÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ