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¾Í¸ã¶¨°¡ ÕâÑù ºÜºÏÀí
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶® ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ· ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar ºÃ¶«Î÷,ϸö¿´¿´ ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡ Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7 µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡ ÔÚPHPÎļþÀï ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡ mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿ ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ ¿ÉÒÔÓÃÈ ......