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
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂ𣿠Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡ ²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡ mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿ ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ ¿ÉÒÔÓÃÈ ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡ Íò·Ö¸Ðл£¡ String SQL=&q ......