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

mysql×ֶθüÐÂÎÊÌ⣡

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


Ïà¹ØÎÊ´ð£º

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

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

MYSQLÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......

Sqlserver Óï¾äת³ÉMySqlÓï¾ä

Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......

MysqlЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

±í
CREATE TABLE `ch1` (
  `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `no` int(10) unsigned DEFAULT NULL,
  `dtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id ......

Çë½Ì£ºÇ¶Èëʽϵͳ°²×°MySQLÊý¾Ý¿âµÄÎÊÌâ

½ñÌìÀÏ´ó²¼ÖøöÈÎÎñ£¬ÒªÎÒÔÚÎÒÃǵIJúÆ·Öа²×°Ò»¸öMYSQLÊý¾Ý¿â£¬ÒªÇóÊÇÈí¼þÕ¼Óÿռ䲻Äܳ¬¹ý5M¡£
ÔÚÍøÉÏÕÒÁ˺þÃҲûÓÐÕÒµ½¹ØÓÚǶÈëʽϵͳÖÐMySQLÊý¾Ý¿âµÄ×ÊÁÏ£¬ÓеÄÒ²Ö»ÊǼòµ¥Ìáһϡ£
ÏÖÌØÏò¸÷λÇë½ÌÒÔÏÂÎÊÌ⣺
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ