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-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
MysqlÖÐÊÇ·ñÓÐÕâÑùµÄȨÏÞÉèÖÃ
ÓÐÒ»¸öÁд洢µÄÊÇÊÖ»úºÅ£¬Ä³Ò»Óû§µÄȨÏÞÔÚ¶ÁÈ¡µÄʱºòÖ»ÏÔʾǰ¼¸Î»£¬ºó¼¸Î»ÓÃÆäËû×Ö·ûÀýÈç*´úÌæ¡£ÀýÈç123456¶Á³öÀ´ÊÇ123***
£¿
¿ÉÒÔ×ö¸öÊÓͼ£¬È»ºó²»¸øÕâ¸öÕ˺űíµÄȨÏÞ£¬½ö¸øÕâ¸öVI ......