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

sqliteµÄ¿ÕÖµ²éѯÔõôд,ÄÜÕߵ÷Ö

sqliteµÄ¿ÕÖµ²éѯÔõôд,ÄÜÕߵ÷Ö
select * from tt where f1 is null

select * from yourTable where col is null;

SQL code:
sqlite> create table Aoqun (id int primary key,col1 int);
sqlite> insert into Aoqun values (1,10);
sqlite> insert into Aoqun values (2,null);
sqlite>
sqlite> select * from Aoqun;
1|10
2|
sqlite> select * from Aoqun where col1 is null;
2|
sqlite>


is null


Ïà¹ØÎÊ´ð£º

sqliteÊý¾Ý¿â²»ÄÜÁ¬Ðø´æÈëÊý¾ÝµÄÎÊÌâ

ÎÒÓÃevc±àдµÄ³ÌÐò£¬½«¶Ô»°¿òÖеÄÊý¾Ý´æÈëÊý¾Ý¿â£¬µÚÒ»´Î¿ÉÒÔ´æÈ룬²»¹ýµÚ¶þ´ÎÊäÈëµÄÊý¾Ý²»ÄÜ´æÈëµ½Êý¾Ý¿âÖС£
ÏÂÃæÊÇÎҵijÌÐò
UpdateData(TRUE); // TODO: Add your control notification handler code here ......

delphi Á¬½ÓsqliteÊý¾Ý¿â£¬insert±¨´í

¿ÉÒÔÌí¼ÓÊý¾Ý£¬µ«ÊǵãÌí¼Óºó»á±¨.access violation at address 0049AB84 in module 

Ô´Âë
procedure Tstudent.add_buttonClick(Sender: TObject);
var
  sqlstr:string;
begin
&nb ......

ÈçºÎö¾ÙsqliteÖеÄËùÓÐ±í¼°Æä×ֶΣ¿£¿

ÎÒÓÐÒ»·ÝsqliteÊý¾Ý¿âÎļþ£¬µ«²»ÖªµÀÀïÃæµÄ±íÃû£¬ÈçºÎö¾Ù³öËùÓеıíÃûÒÔ¼°Æä×Ö¶ÎÃû£¿£¿

¹Ø¼üÊÇsqliteµÄsqlÓï¾äÈçºÎд£¿ÎÒÊÔÁËһЩsqlÓï¾ä²»ÐУ¬ÌØÀ´ÇóÖú¡£

×Ö¶ÎÃû¡¡ÔòÎÞ·¨Ïó±íÃûÒ»Ñù´ÓÊý¾Ý¿âϵͳ±íÖÐÖ±½Ó ......

SQliteµÄÒ»¸öÎÊÌâ

ÈçÏÂÓï¾ä £º
select TimeSpan from T_Table where onlineDate = '2009-12-2'
Êý¾Ý¿âÀïÃæÓзûºÏÌõ¼þµÄÖµµ«ÊDz鲻³öÀ´
Èç¹û¸Ä³ÉÈçÏ£º
select TimeSpan from T_Table where onlineDate = '200 ......

sqlite ²éѯijһÊý¾ÝËùÔÚµÄÐÐÊý

sqlite ²éѯijһÊý¾ÝËùÔÚµÄÐÐÊý£º

ÆäÖÐÊý¾Ý±íÖÐûÓÐרÃűêʶÌõÊýµÄË÷ÒýÖµ£¬ÎÒÃǸù¾ÝÆäËûһЩ×ֶβéÕÒµ½Á˸ÃÊý¾Ý£¬ÏÖÔÚÐèÒª·µ»Ø¸ÃÊý¾ÝËùÔÚµÄÐÐÊý¡£

ÆäÖÐsqlite manager ÖÐÓÐÒ»¸örowid£¬µ«ÊÇÕâ¸ö²¢ÎÞ·¨· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ