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

SQliteµÄÒ»¸öÎÊÌâ

ÈçÏÂÓï¾ä £º
select TimeSpan from T_Table where onlineDate = '2009-12-2'
Êý¾Ý¿âÀïÃæÓзûºÏÌõ¼þµÄÖµµ«ÊDz鲻³öÀ´
Èç¹û¸Ä³ÉÈçÏ£º
select TimeSpan from T_Table where onlineDate = '2009-12-02'
¾Í¿ÉÒÔ²éÕÒ³öÀ´ Ôõô»Øʶù£¬SQlite¾ÍÕâÑùô£¿
»¹ÓÐÏÖÔÚ´Ó³ÌÐò´«ÈëÒ»¸ö DateÀàÐ͵ÄÖµ ¾ÍÊÇ2009-12-2 Õâ¸öÐÎʽµÄ
Ôõô»Øʶù£¬ÓÐʲô°ì·¨¿ÉÒÔ²»¸Ä¶¯³ÌÐò ¾Í¿ÉÒÔÈÃËü²éѯ³ö½á¹ûô£¿


up

×Ô¼º¸ã¶¨ÁË¡£



¡£¡£¡£

ÈÕÆÚ¸ñʽÎÊÌ⣿

strftime("%Y-%m-%d", onlineDate) = '2009-12-2'


Ïà¹ØÎÊ´ð£º

ÇósqlÓï¾ä£¬sqliteÊý¾Ý¿â

µç»°±¾Æ¥Åä²éѯ£¬Ï£ÍûÒ»ÌõÓï¾ä¸ã¶¨
 
¼ÙÉèºÅÂë±¾(numtable)ÈçÏÂ:

ºÅÂë(num)      ÁªÏµÈË (relationname)     
10086          ÒÆ ......

SQLITE ÏÂÃæµÄÓï¾ä¸ÃÔõôд

ÔÚ SQL SERVER ÖеÄÓï¾ä ÊÇ£º
  SELECT
    (ROW_NUMBER() OVER (ORDER BY Name) - 1) / 4 + 1 AS TitleRow,
    (ROW_NUMBER() OVER (ORDER BY Name) - 1) % 4 + 1 AS Title ......

WM³ÌÐò²éѯSQLite¿â×Ü˵±í²»´æÔÚ

.netµÄ³ÌÐò£¬ÓõÄSystem.Data.SQLite DLL
¿âÊÇdb3µÄ£¬²éѯʱ×Ü˵no table **
·¾¶Ò²ÊǶԵÄ
¶øÄǸötableÊÇ´æÔÚµÄ
ÔÚPCÉÏÄÜ¿´µ½
ÇëÎÊÕâ¸öÊÇÔõô»ØÊÂÄØ£¿
ÊÖ»úÉÏÎļþʱûÓÐÏà¶Ô·¾¶µÄ¸ÅÄîµÄ£¬

±¨Ê²Ã ......

delphiÔõÑùÁ¬½ÓSqlite Ôöɾ¸Ä²é

delphiÁ¬½ÓSqlite Ôöɾ¸Ä²éÀý×Ó
Êý¾Ý¿âÒѾ­Á¬Í¨ÁË, ²åÈë»á±¨´í£¬no query specified
with dm.ASQLite3Query1 do
  begin
    dm.ASQLite3Query1.Close;
    dm.ASQLite3 ......

sqliteÒÆÖ²ÎÊÌâ

ÎÒÏÖÔÚÊÖÍ·ÓÐÕâôһ¸öÎÊÌ⣬ÎÒÏëÈÃÒ»¸ö²Ù×÷sqlite3µÄ³ÌÐòÔÚÒ»¸öARM°å×ÓÉÏÅÜÆðÀ´£¬°å×ÓÉϵÄosÊÇwince5.0¡£
ÎÒÊÇÕâô×öµÄ£¬ÎÒÏÈ´Ósqlite3Ö÷Ò³ÏÂÔØÔ´ÂëÏÂÀ´£¬ÓÐÕâô3¸öÎļþ£ºsqlite3.c¡¢sqlite3.h¡¢sqlite3ext.h £¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ