Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

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

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

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

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

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

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

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

¿ÉÒÔÓÃÈ ......

ÔõôÔÚeclipseÏÂÏòmysql²åÈë±äÁ¿°¡ - Java / JavaÏà¹Ø

String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡­¡­µ½µ×¸Ãզд°¡

Íò·Ö¸Ðл£¡

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