Ò»¸ö×Ö¶ÎÆ¥ÅäµÄsqlÓï¾äÊéд
Õ⼸Ì츺ÔðÒ»¸ö¼Ò½ÌÃÅ»§ÍøÕ¾µÄ¿ª·¢£¬»ùÓÚcakephp¿ò¼Ü¡£ÔÚÅàѵ»ú¹¹±í£¨schools£©ÖдæÔÚÒ»¸ö×Ö¶ÎsubjectÓÃÀ´´æ´¢ÁíÒ»¸öÊý¾Ý±í
£¨subjects£©ÖмǼµÄidÖµ£¬ÇÒ´æ´¢ÐÎʽΪ£º'1,2,3,4,5'¡£µ«ÊÇÔÚÓ¦Óø߼¶ËÑË÷¹ýÂËʱҳÃæselectÑ¡ÏîoptionµÄ´«ÖµÎª
subjectsµÄidÖµ£¬ÐèÒªÅжϲéѯ±íschoolsÖÐsubject×ֶδæÔÚ´Ëid£¬¼´²éѯÏÔʾ´Ë¼Ç¼¡£
ÏȺó³¢ÊÔÁËÒÔϼ¸ÖÖ·½Ê½£º
**Ôڴ˼ÙÉèid´«ÖµÎª3**
1. SELECT * from schools WHERE subject like '%3%'£»»á³öÏÖ²éѯ³ö´æÔÚ'1£¬2£¬3','1£¬13£¬33'µÄ¼Ç¼£¬²»ºÏÂß¼.
2. SELECT * from schools WHERE subject in (3)£»»á³öÏÖ²éѯ³ö '3'£¬¶ø²»»á²éѯ³ö´æÔÚ '1£¬3','1£¬2£¬3' µÄ¼Ç¼£¬²»ºÏÂß¼
3. SELECT * FORM schools WHERE find_in_set('3', subject); ¿ÉÒԺܺõĽâ¾öÁËÒÔÉÏÎÊÌâ¡£
ΪÁ˸üÉîÈëµÄÁ˽âÒ»ÏÂfind_in_set()º¯Êý£¬mysqlÊÖ²áÖжԴ˽âÊÍÈçÏ£º
FIND_IN_SET(str,strlist)
¼ÙÈç×Ö·û´®str ÔÚÓÉN ×ÓÁ´×é³ÉµÄ×Ö·û´®Áбístrlist ÖУ¬Ôò·µ»ØÖµµÄ·¶Î§ÔÚ 1 µ½ N
Ö®¼ä¡£Ò»¸ö×Ö·û´®Áбí¾ÍÊÇÒ»¸öÓÉһЩ±»‘,’·ûºÅ·Ö¿ªµÄ×ÔÁ´×é³ÉµÄ×Ö·û´®¡£Èç¹ûµÚÒ»¸ö²ÎÊýÊÇÒ»¸ö³£Êý×Ö·û´®£¬¶øµÚ¶þ¸öÊÇtype SETÁУ¬Ôò
FIND_IN_SET() º¯Êý±»ÓÅ»¯£¬Ê¹ÓñÈÌؼÆËã¡£Èç¹ûstr²»ÔÚstrlist »òstrlist Ϊ¿Õ×Ö·û´®£¬Ôò·µ»ØֵΪ 0
¡£ÈçÈÎÒâÒ»¸ö²ÎÊýΪNULL£¬Ôò·µ»ØֵΪ NULL¡£ Õâ¸öº¯ÊýÔÚµÚÒ»¸ö²ÎÊý°üº¬Ò»¸ö¶ººÅ(‘,’)ʱ½«ÎÞ·¨Õý³£ÔËÐС£
Ïà¹ØÎĵµ£º
Ò»¡¢sqlÊéд¹æ·¶£º
1¡¢sqlÓï¾äµÄËùÓбíÃû¡¢×Ö¶ÎÃûÈ«²¿Ð¡Ð´£¬ÏµÍ³±£Áô×Ö¡¢ÄÚÖú¯ÊýÃû¡¢sql±£Áô×Ö´óд¡£
2¡¢Á¬½Ó·ûor¡¢in¡¢and¡¢ÒÔ¼°£½¡¢<=¡¢>=µÈÇ°ºó¼ÓÉÏÒ»¸ö¿Õ¸ñ¡£
3¡¢¶Ô½ÏΪ¸´ÔÓµÄsqlÓï¾ä¼ÓÉÏ×¢ÊÍ£¬ËµÃ÷Ëã·¨¡¢¹¦ÄÜ¡£
&nb ......
ÎÒÃÇÔÚ¿ª·¢¹ý³ÌÖУ¬¾³£Óöµ½ÕâÑùÎÊÌ⣬¾ÍÊÇÒªÇó¶¨ÆÚ½øÐÐÊý¾Ý¿âµÄ¼ì²é£¬Èç¹û·¢ÏÖÌض¨Êý¾Ý£¬ÄÇô¾ÍÒª½øÐÐijÏî²Ù×÷£¬Õâ¸öÐèÇóÄØ£¬¿ÉÒÔÀûÓÃWindowsµÄ¼Æ»®ÈÎÎñ£¬¶¨ÆÚÖ´ÐÐijһ¸öÓ¦ÓóÌÐò£¬È¥¼ìË÷Êý¾Ý£»Ò²¿ÉÒÔÈóÌÐò×Ô¼º¿ØÖÆ¡£ÆäʵSQL Server×Ô¼ºÒ²¿ÉÒÔ´´½¨¼Æ»®ÈÎÎñ£¬¶¨ÆÚ½øÐÐÖ´ÐС£Èç¹ûÊý¾Ý¿â·þÎñÆ÷ÔÊÐí£¬¿ÉÒÔ¿¼ÂDzÉÓÃÕâÖÖ·½Ê½¡£
......
½ñÌì°²×°SQL SERVER 2000 ¸öÈ˰棬°²×°×îºóµ¯³ö´íÎó¶Ô»°¿ò£º
“°²×°³ÌÐòÅäÖ÷þÎñÆ÷ʧ°Ü¡£²Î¿¼·þÎñÆ÷´íÎóÈÕÖ¾ºÍC:\windows\sqlstp.log”£¬´Ó¶øÎÞ·¨°²×°¡£
µ½¾ßÌåµÄĿ¼²é¿´ÏÔʾ"Ò»°ãÐÔÍøÂç´íÎó"£¬ÔÚÍøÉÏËÑË÷ÎÊÌâÔÒò¼°½â¾ö·½°¸ÈçÏ£º
´ËÎÊÌâÊôÓÚsql serverµÄbug, GetComputerName ÓÃÓÚ»ñÈ¡±¾µØ¼ÆËã»úÃû¡£ ......
ÎÒÃÇÔÚƽ³£µÄϵͳ¿ª·¢Öг£³£»áÓöµ½ÏñÎÞÏÞ¼¶·ÖÀàÕâÑùµÄÊ÷ÐͽṹÊý¾Ý£¬ÏÖÌṩһ¸ö¿ÉÓõÄÊý¾Ý¿â´æ´¢¹ý³Ì£¬¿ÉÒÔÍê³ÉÊ÷ÐͽṹÊý¾ÝµÄÅÅÐò¡£
»·¾³£ºwindows7+Sql Server 2008
˵Ã÷£ºÏÂÃæ´úÂëÒѾת»»³ÉSql server2000µÄ½Å±¾£¬´¦ÀíЧ¹ûÈçÏ£¬¿´sortname×ֶνá¹û,´úÂë¾¹ý²âÊÔ¡£
´´½¨Ê÷Ðͱí
CREATE TABLE [dbo].[categories](
......
1.ʹÓÃCÓïÑÔÀ´²Ù×÷SQL SERVERÊý¾Ý¿â,²ÉÓÃODBC¿ª·ÅʽÊý¾Ý¿âÁ¬½Ó½øÐÐÊý¾ÝµÄÌí¼Ó,ÐÞ¸Ä,ɾ³ý,²éѯµÈ²Ù×÷¡£
step1:Æô¶¯SQLSERVER·þÎñ,ÀýÈç:HNHJ,¿ªÊ¼²Ëµ¥ ->ÔËÐÐ ->net start mssqlserver
step2:´ò¿ªÆóÒµ¹ÜÀíÆ÷,½¨Á¢Êý¾Ý¿âtest,ÔÚtest¿âÖн¨Á¢test±í(a varchar(200),b varchar(200))
step3:½¨Á¢ÏµÍ³DSN,¿ªÊ¼²Ëµ ......