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

mysql ÓÐûÓÐsplit

ÓÐûÓÐsplit »òÊÇÓÐʲô°ì·¨¿ÉÒÔÈ¡´úsplit ÄØ£¿

ÎÒÒª´«Èë´æ´¢¹ý³ÌÒ»¸ö (subject1,subject2,subject3,subject4......)
ÀàËÆÕâÑùµÄÒ»¸ö´®£¬È»ºóÔÚ¹ý³ÌÀïÃæÓÃ(,)¸ø·Ö¿ª

Óм¸¸öÔªËØ¾Í·Ö±ðÈ¥Ö´ÐÐÒ»¸ösqlÓï¾ä¡£

INSERT INTO cm_sys_student(studentid,syscategoryid,enroldate)SELECT uid,id,SYSDATE() 
from cm_sys_cocategory WHERE CATEGORYNUM = ºìÉ«ÇøÓò£¬ÓÃ","·Ö¿ªµÄÿһ¸ö×Ö·û;


ºìÉ«ÇøÓòÓм¸¸öÖµ¾ÍÖ´Ðм¸´ÎsqlÓï¾ä.

ÈçºÎʵÏÖºô£¿
û¿´¶®ÄãµÄÐèÇó¡£ Äã¿ÉÒÔͨ¹ý×Ö·û´®´¦Àíº¯Êý£¬Ò»¸öÒ»¸öÈ¡³ö°¡¡£

ûÓÐÖ±½ÓµÄ SPLIT() º¯Êý£¬ÄãÐèÒª×Ô¼º¸ù¾Ý , À´´¦Àí¡£


¿ÉÒԲο¼Õâ¸öÌù×Ó¡£

http://topic.csdn.net/u/20100414/14/e188a860-a36c-41a4-aeb8-8e66f1ccb83a.html

°æÖ÷ÌùÖ÷ÖÐÎçºÃ£¡
°æÖ÷ÌùÖ÷ÿÌì¶¼ÓкÃÐÄÇ飡

MWP3CvJEeEeuMzb»ØÌûÊÇÒ»ÖÖÃÀµÂ£¡Cnw62CNaKpoWdY3
==========================
½é+ÉÜ:

http://spritebrowser.com

iqRD1BlxmYEbMMb
£±£©¿ÉÂ¼ÖÆÉÏÍø¼Ç¼£¬½Ø»ñHttpÐÅÏ¢¡£
£²£©ÀûÓýػñµÄHttpÐÅÏ¢×Ô¶¯Éú³ÉÃüÁPage,ÍÏ×§¼´¿ÉÍê³É£©
£³£©Ö´ÐÐÃüÁģÄâä¯ÀÀÆ÷ÏòWeb·þÎñÆ÷·¢ÉúÃüÁî¡£

ÖÐÎÄÂÛ̳£ºhttp://spritebrowser.com/LunTan
MWP3CvJEeEeuMzb

·¢ÏÖһȺÃÀÅ®£º
http://byhat.com

=======================
Èí¼þ´´ÒµQQ qunȺ£º103815692

PYCaDPzEgFHtp4V

²Î¿¼Â¥ÉÏÀÇÍ·µÄ

±ÈÈçÏÖÔÚÓÐÒ»×Ö·û´®£º1,2,44,5,666,29232
Òª°ÑËü°´ÕÕ¶ººÅ·Ö¸î³É£º
1
2
44
5
666
29232
¶øÇÒ»¹ÒªÇóËüµÄ×ÜÊý¡£


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

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

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

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......

MysqlȨÏÞ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

MysqlÖÐÊÇ·ñÓÐÕâÑùµÄȨÏÞÉèÖÃ
ÓÐÒ»¸öÁд洢µÄÊÇÊÖ»úºÅ£¬Ä³Ò»Óû§µÄȨÏÞÔÚ¶ÁÈ¡µÄʱºòÖ»ÏÔʾǰ¼¸Î»£¬ºó¼¸Î»ÓÃÆäËû×Ö·ûÀýÈç*´úÌæ¡£ÀýÈç123456¶Á³öÀ´ÊÇ123***
£¿
¿ÉÒÔ×ö¸öÊÓͼ£¬È»ºó²»¸øÕâ¸öÕ˺űíµÄȨÏÞ£¬½ö¸øÕâ¸öVI ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ