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
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
½ñÌìÀÏ´ó²¼ÖøöÈÎÎñ£¬ÒªÎÒÔÚÎÒÃǵIJúÆ·Öа²×°Ò»¸öMYSQLÊý¾Ý¿â£¬ÒªÇóÊÇÈí¼þÕ¼Óÿռ䲻Äܳ¬¹ý5M¡£
ÔÚÍøÉÏÕÒÁ˺þÃҲûÓÐÕÒµ½¹ØÓÚǶÈëʽϵͳÖÐMySQLÊý¾Ý¿âµÄ×ÊÁÏ£¬ÓеÄÒ²Ö»ÊǼòµ¥Ìáһϡ£
ÏÖÌØÏò¸÷λÇë½ÌÒÔÏÂÎÊÌ⣺
......