SQL ÖÐ where 1=1 ºÍ 1=0µÄ ×÷ÓÃ
where 1=1ÓÐʲôÓã¿ÔÚSQLÓïÑÔÖУ¬Ð´Õâôһ¾ä»°¾Í¸úûдһÑù¡£
select * from table1 where 1=1Óëselect * from table1ÍêȫûÓÐÇø±ð£¬ÉõÖÁ»¹ÓÐÆäËûÐí¶àд·¨£¬1<>2£¬'a'='a','a'<>'b'£¬ÆäÄ¿µÄ¾ÍÖ»ÓÐÒ»¸ö£¬whereµÄÌõ¼þΪÓÀÕæ£¬µÃµ½µÄ½á¹û¾ÍÊÇδ¼ÓÔ¼ÊøÌõ¼þµÄ¡£
ÔÚSQL×¢Èëʱ»áÓõ½Õâ¸ö£¬ÀýÈçselect * from table1 where name='lala'¸øÇ¿ÐмÓÉÏselect * from table1 where name='lala' or 1=1Õâ¾ÍÓÖ±ä³ÉÁËÎÞÔ¼ÊøµÄ²éѯÁË¡£
×î½ü·¢ÏÖµÄÃîÓÃÔÚÓÚ£¬ÔÚ²»¶¨ÊýÁ¿²éѯÌõ¼þÇé¿öÏ£¬1=1¿ÉÒԺܷ½±ãµÄ¹æ·¶Óï¾ä¡£ÀýÈçÒ»¸ö²éѯ¿ÉÄÜÓÐname,age,height,weightÔ¼Êø£¬Ò²¿ÉÄÜûÓУ¬ÄǸÃÈçºÎ´¦ÀíÄØ£¿
String sql=select * from table1 where 1=1
ΪʲôҪд¶àÓàµÄ1=1£¿ÂíÉϾÍÖªµÀÁË¡£
if(!name.equals("")){
sql=sql+"name='"+name+"'";
}
if(!age.equals("")){
sql=sql+"age'"+age+"'";
}
if(!height.equals("")){
sql=sql+"height='"+height+"'";
}
if(!weight.equals("")){
sql=sql+"weight='"+weight+"'";
}
Èç¹û²»Ð´1=1ÄØ£¬ÄÇôÔÚÿһ¸ö²»Îª¿ÕµÄ²éѯÌõ¼þÃæÇ°£¬¶¼±ØÐëÅжÏÓÐûÓÐwhere×־䣬·ñÔòÒªÔÚµÚÒ»¸ö³öÏֵĵط½¼Ówhere
ÓÐÒ»´ÎÔÚÂÛ̳Àï¿´µ½£º"SELECT * from strName WHERE 1 = 0";
²»Àí½âΪʲôÓÐ1=0£¿
¸ÃselectÓï¾äÖ÷ÒªÓÃÓÚ¶ÁÈ¡±íµÄ½á¹¹¶ø²»¿¼ÂDZíÖеÄÊý¾Ý£¬ÕâÑù½ÚÊ¡ÁËÄڴ棬ÒòΪ¿ÉÒÔ²»Óñ£´æ½á¹û¼¯¡£
ÁíÍ⣬Õâ¸öÓÃÔÚʲôµØ·½ÄØ£¿Ö÷ÒªÓÃÓÚ´´½¨Ò»¸öÐÂ±í£¬¶øÐ±íµÄ½á¹¹Óë²éѯµÄ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ¡£ÈçÏÂSQLÓï¾ä£º
create table newtable as select * from oldtable where 1=0;
Ïà¹ØÎĵµ£º
ÔÚ×ösqlÌâʱ£¬ÎÒÃÇ×îÅÂÓöµ½Ìõ¼þ¸´ÔӵIJéѯÓï¾ä£¬ÒòΪ´ó¶àʱºòÐèÒªÁ½Èý¸ö×Ó²éѯÀ´ÊµÏÖ£¬
¶ø´ó¶àÊýͬѧ£¬¿ÉÒÔ˵¶¼±È½ÏÅÂ×Ó²éѯµÄ£¬ÒÔǰÎÒÒ²±»ÕâЩÌâĿŪµÄÔÆÀïÎíÀïµÄ£¬
²»¹ý×ö¶àÁËÕâÀàµÄÌâÄ¿ºó·¢ÏÖ£¬ÆäʵҲÓÐÒ»¶¨¹æÂÉ£¬ÎÒÃÇ¿ÉÒÔ×ܽáÒ»Ì×ÊʺÏ×Ô¼ºµÄ·½·¨À´´¦Àí£¬
ÏÂÃæÊ±ÎÒ¶Ô¸ÃÀàÌâÄ¿µÄ´¦Àí·½·¨£º
ÓйºÎï±íÈçÏ£º
ÌâÄ¿£º ²é ......
½ñÌìÔÚһ̨Ðé»úÉϰ²×° sql server 2005£¬¾ÓÈ»±¨1´íÁË£¨ÎÞÓïÁË£¬×°Õâ¸ö¶«Î÷¶¼Åª²»ºÃ%>_<%£©¿ªÊ¼ÒÔΪÊÇÒòΪADÓòµÄÔÒò£¬ºóÀ´É¾µôÓòÓÖÖØ½¨Óò£¬È»ºóÔÙ×°£¬ÓÖ±¨2´í£¬ÓÚÊÇÎʱðÈËËÑË÷µÈµÈ£¬ÕÒµ½ÔÒòËµÒªÖØÐÂ×¢²áinstaller£¬×îÖÕ°²×°³É¹¦ÁË£¬º¦ÎÒ¼Ó°à۵쬏ßÐ˵ÄÊǰ²×°ºÃÀ²£¬¿ÉÊÇÎÒûÓÐŪÃ÷°×µ½µ×ÊÇɶÔÒòµ¼ÖÂsql°²×°²»ÁËÄØ£ ......
ORACLEPL/SQL»ù´¡--ÓαêµÄѧϰÀ´Ô´£º
Óαê×ÖÃæÀí½â¾ÍÊÇÓζ¯µÄ¹â±ê¡£
ÓÃÊý¾Ý¿âÓïÑÔÀ´ÃèÊö£ºÓαêÊÇÓ³ÉäÔÚ½á¹û¼¯ÖÐÒ»ÐÐÊý¾ÝÉϵÄλÖÃʵÌ壬ÓÐÁËÓαêÓû§¾Í¿ÉÒÔ·ÃÎʽá¹û¼¯ÖеÄÈÎÒâÒ»ÐÐÊý¾ÝÁË£¬½«Óαê·ÅÖõ½Ä³Ðк󣬼´¿É¶Ô¸ÃÐÐÊý¾Ý½øÐвÙ×÷£¬ÀýÈçÌáÈ¡µ±Ç°ÐеÄÊý¾ÝµÈµÈ¡£
......
1. Èç¹ûÄãÏ£ÍûʹÓÃselcet topÓï¾ä£¬²¢ÇÒ»¹Òª¸½´øwhereÌõ¼þ£¬ÄÇôÌõ¼þÖеÄÁо͵ÃÊǺÏÊʵÄË÷Òý£¬Èç¾Û¼¯Ë÷Òý¡¢¸´ºÏË÷ÒýÀïµÄÖ÷ÁÐ
µÈ£¬Í¬Ê±£¬whereÌõ¼þÀïÒ²Òª¾¡Á¿±Ü¿ªÊ¹Óú¯Êý£¬or£¬ÅжÏNULLµÈ»áÒýÆðÈ«²¿É¨ÃèµÄÓï¾ä£¬²»È»Ö´ÐеÄÊÇÈ«±íɨÃè¡£
2. ͨ¹ýÉèÖÃSTATISTICSÎÒÃÇ¿ÉÒԲ鿴ִÐÐSQLʱµÄÖ´ÐÐЧÂÊÒÔ¼°Ïà¹ØÐÔÄܲâÊÔ ......