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

±È½Ï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²Ù×÷¡£

Êý¾ÝÁ¿Ì«Ð¡£¬²»¾ßÓдú±íÐÔ£¬Ó¦¸ÃËÙ¶ÈÒ»Ñù¡£×Ô¼º¿ÉÒÔÉú³ÉǧÍò×óÓÒµÄÊý¾ÝÊÔÊÔ

Ï£ÍûÓиöȨÍþµÄ´ð°¸³öÀ´¡£
ºÇºÇ£¬


¿´Ò»Ï²éѯ¼Æ»®ÁË¡£Ó¦¸ÃÊÇÒ»ÑùµÄ¡£

Ò»ÑùµÄ


Ïà¹ØÎÊ´ð£º

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

sqlserver´íÎó - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

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

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

MySQL 5.1²Î¿¼ÊÖ²á

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

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ