Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Îļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

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

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

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......

mysqlÎÊÌ⣡ - Java / Java SE

String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......

ÈçºÎÔÚMySQL ServerÖж¨Ê±²åÈëÊý¾Ý - Java / Web ¿ª·¢

ÎÒÏÖÔÚÏëÓÃJSPʵÏÖQQÓÊÏäÀïµÄ¶¨Ê±·¢ËÍ£¬ÎÒÏëͨ¹ýÊý¾Ý¿â½øÐж¨Ê±²åÈëÊý¾Ý¡£
µ«²»ÖªµÀÈçºÎʵÏÖ£¬»òÕß´ó¼ÒÓиüºÃµÄ·½·¨£¬²»Ò»¶¨ËµÊÇÊý¾Ý¿â¡£
Çë´ó¼Ò¸øµãÒâ¼û£¬°ÝлÀ²¡£

quataz¶¨Ê±Æ÷×é¼þÊǸöºÜºÃµÄ½â¾ö·½°¸¡£

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