Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿âÂð£¿

visual studioÏÂÔÚwmÄ£ÄâÆ÷À³ÌÐò²Ù×÷sqlite¶¼Ê§°Ü£¬µ«ÔÚÊÖ»úÉÏûÎÊÌ⣬´ó¼ÒÆձ鶼ÊÇÕâÑùÂð£¿Ë­Óнâ¾ö°ì·¨£¿±Ï¾¹ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔЧÂʱȽϸߡ£
¶÷£¬²»»á°¡£¬PPCµÄÄ£ÄâÆ÷ÊÇ¿ÉÒԵİ¡..

ÒýÓÃ
¶÷£¬²»»á°¡£¬PPCµÄÄ ......

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 ......

sqliteÒÆÖ²ÎÊÌâ

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