mysqlÊý¾Ý¿â ±íÖÐÓÐÁ½¸ö×ֶΣºid name ides ÆäÖÐidesÖµ¿ÉÄÜΪ£º1 Ò²¿ÉÄÜΪ 1,2,3,4,5,6,7,8,9,10,11,12,13,14 ....ÀàËÆµÄÊý×Ö¼¯ºÏ Ò»¹²ÓкܶàÌõ£¡£¡£¡ ÏÖÔÚÒª¸üеÄÌõ¼þÊÇ£º ½«ËùÓÐÊý¾Ý idesÖеÄ3Êý¾ÝÒÆ³ý£¬3¿ÉÄÜÔÚÖм䣬Ҳ¿ÉÄÜÊǵÚÒ»¸ö£¬×îºóÒ»¸ö£¬Ò²¿ÉÄÜÒ»¸ö×ֶξÍÒ»¸ö3 ÓÃÒ»ÌõsqlÓï¾äÈçºÎʵÏÖ£¿Ð»Ð»£¡ ÈçÉÏÓï¾äÒÆ³ýºó idesӦΪ 1,2,4,5,6...
UPDATE TT SET F1= REPLACE(CONCAT(',',F1,','),',3,',',') лл£¡Â¥Éϵķ½·¨¿ÉÒÔÌæ»»£¬²»¹ý»¹ÓÐÒ»¸ö¶àÓàµÄ¶ººÅ£¬Äܲ»ÄܰѶººÅҲȥµô¡£ ǰÁ½ÌìÓÐÈËÎʹýÁË¡£ set @x='1,2,3,4,5,6' select substring(replace(concat(',',@x,','),',1,',',9,'),2,length(@x)) http://topic.csdn.net/u/20100107/13/51fc0239-cce3-47bd-99ca-c98b104e1192.html?95385 ÒýÓà MYSQLÕýÔòʽֻÄܽøÐÐÆ¥Å䣬ÎÞ·¨ÊµÏÖÌæ»»¡£ Äã¿ÉÒÔÓÃÈçϺ¯Êý×éºÏʵÏÖ SQL code mysql> set @x='1,2,3,4,5,6'; Query OK, 0 rows affected (0.00 sec) mysql> select substring(replace(concat(',',@x,','),',1,',',9,'),2,length(@x)); +-----------------------------------------------------------------+ | substring(replace(concat
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡ mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿ ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ ¿ÉÒÔÓÃÈ ......