±È½Ïsql µÄËÙ¶È
Ò»¸ö20WÌõÊý¾ÝµÄ±í,²éѯÌõ¼þÓï¾ä Äĸö¿ìÒ»µã. 1.where id in (1,2,3,4) 2.where id=1 or id=2 or id=3 or id=4
»¢ÄêºÃÔË£¡»¢ÄêºÃÔË£¡ SQL code: select * from tb where id=1 union all select * from tb where id=2 union all select * from tb where id=3 union all select * from tb where id=4 ¿´Êý¾Ý¿â·Ö²¼Çé¿öÁË£¬in¿ÉÒÔÓÃÉÏË÷Òý£¬Èç¹û¹ýÂ˵ıȽ϶àµÄ»°£¬¿ÉÄÜ»á¿ìÒ»µã¡£ ============================================================== ¹ú²úÊý¾Ý¿âµÚÒ»Æ·ÅÆ£ºhttp://bbs.dameng.com ============================================================== ¿´Êý¾Ý·Ö²¼Çé¿öÁË£¬in¿ÉÒÔÓÃÉÏË÷Òý£¬Èç¹û¹ýÂ˵ıȽ϶àµÄ»°£¬¿ÉÄÜ»á¿ìÒ»µã¡£ÒýÓà һ¸ö20WÌõÊý¾ÝµÄ±í,²éѯÌõ¼þÓï¾ä Äĸö¿ìÒ»µã. 1.where id in (1,2,3,4) 2.where id=1 or id=2 or id=3 or id=4 ½éÒâд³É2Â¥µÄ¸ñʽ µÚÒ»ÖÖд·¨¿Ï¶¨²»¿ì IDÁÐÉϽ¨Á¢Ë÷ÒýµÄ»°£¬IN£¨1£¬2£¬3£¬4£©Ó¦¸Ã¿ìЩ¡£ Õâ¸ö¶¼²»¿ì£¬Ë÷Òý×î¿ì,½¨ÒéÓÃË÷ÒýÊÔÊÔ ËÙ¶ÈÂýÊÇÒòΪÓñʼDZ¾²âÊÔµÄ Ò»ÑùµÄ¡£ »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡ ÀíÂÛÉÏÀ´ËµÊÇÒ»Ñù¿ìµÄ¡£ÒòΪin²Ù×÷¿ÉÒԵȼÛÓëor²Ù×÷¡£ Êý¾ÝÁ¿Ì«Ð¡£¬²»¾ßÓдú±íÐÔ£¬Ó¦¸ÃËÙ¶ÈÒ»Ñù¡£×Ô¼º¿ÉÒÔÉú³ÉǧÍò×óÓÒµÄÊý¾ÝÊÔÊÔ Ï£ÍûÓиöȨÍþµÄ´ð°¸³öÀ´¡£ ºÇºÇ£¬ ¿´Ò»Ï²éѯ¼Æ»®ÁË¡£Ó¦¸ÃÊÇÒ»ÑùµÄ¡£ Ò»ÑùµÄ
Ïà¹ØÎÊ´ð£º
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬ sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º ÈÕÆÚ 2010-1-25 14:45: ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬ »òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡ ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡 ֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡ °ïUP ²Î¿¼:http://hi.baidu.com/toiota ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£© tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname ½á¹û£º µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿ MySQL 5.1²Î¿¼ÊÖ²á ÒýÓà ÐÖµÜÄã»á½áÌùÂ𣿠mysql ²Î¿¼ÊÖ²á baidu MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......