sqlite²»»á²»Ö§³Öand °É? select * from table where rootid=2 and uid=0 order by orderid asc,id asc ʹÓÃÉÏÃæµÄÓï¾ä²éѯ²»µ½Êý¾Ý,¿ÉÊÇ·ûºÏµÄÌõ¼þÊÇ´æÔÚµÄ.ÎÒÈ¡µôand,¾ÍÓмǼ,²»ÖªµÀÔõô»ØÊ select * from table where rootid=2 order by orderid asc,id asc ÊÔÒ»ÏÂselect * from table where uid=0;
ÕâÑùÊÇ¿ÉÒÔµÄ,¿ÉÊǺóÃæ¼ÓÉÏÁíÒ»¸öÌõ¼þ,ÎÒÊÔ¹ýÁË,and roorid=1¿ÉÒԲ鵽,¿ÉÊÇand roorid=2¾Í²é²»µ½ÁË,µ«ÎÒ¿´Êý¾Ý¿â,·ûºÏÌõ¼þµÄ,Óа¡ ³öÏÖÕâÖÖÇé¿ö?ÎÒ²ÂÓ¦¸ÃÊÇÄãµÄÊý¾Ý¿âÓÐÎÊÌâÁË,ÖØÐÂÏÂÔØÒ»¸ö°²×°°É! ÎÒ¸Õ²ÅɾÁËÈ«²¿Êý¾Ý,´ÓмÓÁËÁ½Ìõ,ÊÔÁËÏÂselect * from table where uid=0;ÕâÌõ,²»ÐÐ,²é²»µ½,²»ÖªµÀʲôÔÒò,uidÊÇÊý×é×Ö¶Î,ÎÒÒª²éѯµÈÓÚ0µÄ,ÄѵÀ²»ÊÇÕâÑùÂð? "Êý×é×Ö¶Î"ʲôÒâ˼? ¼ÈÈ» uid=0 ûÓнá¹û ÄÇô rootid=2 and uid=0 ¾Í¸ü²»»áÓнá¹ûÁË¡£ ÎÒµÄÒâ˼ÊÇ,uid=0µÄÊý¾ÝÊÇ´æÔÚµÄ,µ«ÊDzéѯ²»µ½. ½¨ÒéÖØ×° ¿Ï¶¨ÊÇÄÄĬÈϵÄÅäÖÃÎÊÌâ³ö´í³åÍ»ÁË
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......