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'
Ïà¹ØÎÊ´ð£º
µç»°±¾Æ¥Åä²éѯ£¬Ï£ÍûÒ»ÌõÓï¾ä¸ã¶¨
¼ÙÉèºÅÂë±¾(numtable)ÈçÏÂ:
ºÅÂë(num) ÁªÏµÈË (relationname)
10086 ÒÆ ......
visual studioÏÂÔÚwmÄ£ÄâÆ÷À³ÌÐò²Ù×÷sqlite¶¼Ê§°Ü£¬µ«ÔÚÊÖ»úÉÏûÎÊÌ⣬´ó¼ÒÆձ鶼ÊÇÕâÑùÂð£¿ËÓнâ¾ö°ì·¨£¿±Ï¾¹ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔЧÂʱȽϸߡ£
¶÷£¬²»»á°¡£¬PPCµÄÄ£ÄâÆ÷ÊÇ¿ÉÒԵİ¡..
ÒýÓÃ
¶÷£¬²»»á°¡£¬PPCµÄÄ ......
ÔÚ 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 ......
ÎÒÏÖÔÚÊÖÍ·ÓÐÕâôһ¸öÎÊÌ⣬ÎÒÏëÈÃÒ»¸ö²Ù×÷sqlite3µÄ³ÌÐòÔÚÒ»¸öARM°å×ÓÉÏÅÜÆðÀ´£¬°å×ÓÉϵÄosÊÇwince5.0¡£
ÎÒÊÇÕâô×öµÄ£¬ÎÒÏÈ´Ósqlite3Ö÷Ò³ÏÂÔØÔ´ÂëÏÂÀ´£¬ÓÐÕâô3¸öÎļþ£ºsqlite3.c¡¢sqlite3.h¡¢sqlite3ext.h £¬ ......