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

SQLiteÊý¾Ý¿âʹÓÃ×ܽá

1.ÔÚSQLiteÖвåÈ뵱ǰʱ¼ä,±äÁ¿¶¨Òå²»Óöà˵
char *sql = sqlite3_mprintf("insert into Log VALUES(datetime('now', 'localtime'), '%q', '%q')", cUser, cLogContent);
int ret = sqlite3_exec(Sqlite3, sql, NULL, NULL, &pErrMsg);
ÒÔÔ·ÝΪµ¥Î»Í³¼Æ³ö·ûºÏµ±Ç°Ô·ݵļǼ, TimeΪÊý¾Ý¿âÖÐ×Ö¶ÎÃû:
char *sql = sqlite3_mprintf("select * from Log where Time>=datetime('now','start of month') order by Time DESC");
sqlite3_prepare(sqlite3_db, sql, -1, &pStmt, &pzTail);
int ret = sqlite3_step(pStmt);
while (ret == SQLITE_ROW)
{
    ...
    ret = sqlite3_step(pStmt);
}
ÒÔʱ¼ä¶ÎÀ´²éѯ,½çÃæÌáʾµÄʱ¼äΪYYYY-MM-DD¸ñʽ,cStartTime, cEndTimeΪchar *´¢´æµÄÊÇʱ¼äYYYY-MM-DD:
char *sql = sqlite3_mprintf("select * from Log where Time between datetime('%q','start of day') and datetime('%q','start of
day','+1 day') order by Time DESC", cStartTime, cEndTime);
sqlite3_prepare(sqlite3_db, sql, -1, &pStmt, &pzTail);
int ret = sqlite3_step(pStmt);
while (ret == SQLITE_ROW)
{
    ...
    ret = sqlite3_step(pStmt);
}
2.×¢Òâ:ÇмÇÔÚ´íÎó´¦ÀíÖÐ,Ò²Òª°Ñ´ò¿ªµÄÊý¾Ý¿â¹Ø±Õ,²»È»´øÀ´²»±ØÒªµÄÂé·³
3.´óÁ¿Êý¾Ý´¦ÀíÊÇ,ÓÃÊÂÎñ,ʰ빦±¶
4.ÓÃsqlite3_open16(L"data.db", &m_sqlite3);´ò¿ªÊý¾Ý¿âʱ,±ØÐë¼ÓÉÏL


Ïà¹ØÎĵµ£º

sqlite´úÂëµÄ±àд

 ÏÂÔØ´úÂë
È¡µÃÒ»·Ý¶þ½øÖÆ¿½±´, »òÕßÊÇÔ´´úÂë²¢×Ô¼º±àÒëËü. ¹ØÓÚ ÏÂÔØÒ³£¨download£© µÄ¸ü¶àÐÅÏ¢.
´´½¨Ò»¸öÐÂÊý¾Ý¿â
ÔÚ DOS ÃüÁîÐÐÏÂ, ÊäÈë: "sqlite3 test.db". ½«´´½¨Ò»¸öеÄÊý¾Ý¿âÎļþÃû½Ð"test.db". (Äã¿ÉÒÔʹÓò»Í¬µÄÃû×Ö)
ÊäÈë SQL ÃüÁîÔÚÌáʾ·ûÏ´´½¨ºÍдÈëеÄÊý¾Ý.
д³ÌÐòʹÓà SQLite
ÏÂÃæÊÇÒ»¸ö¼òµ¥µ ......

ÔÚ.NET C#ÖÐʹÓÃsqlite

 1¡£´Ówww.sqlite.orgÏÂÔØSQLite 3.3.4µÄ°æ±¾
ΪÁË·½±ã£¬ÎÒ°ÑËü½âѹÁË£¬¾ÍÒ»¸öSQLite3.exe£¬·ÅÈëWindowsĿ¼Ï¡£
Cmd ½øÈëÃüÁîÐÐ
1)
´´½¨Êý¾Ý¿âÎļþ:
>SQLite3 d:\test.db »Ø³µ
¾ÍÉú³ÉÁËÒ»¸ötest.dbÔÚdÅÌ¡£
ÕâÑùͬʱҲSQLite3¹ÒÉÏÁËÕâ¸ötest.db
2)
ÓÃ.help¿ÉÒÔ¿´¿´ÓÐʲôÃüÁî
>.help »Ø³µ¼´¿É
3)¿ÉÒ ......

SQLite Tutorial in PHP

 
SQLite Tutorial in PHP
SQLite is an SQL database manager used locally or on a website, and compatible
in particularly with PHP.
Summary
Installing SQLite and creating a database
.
Installing SQLite. Verifying the installation by creating a base.
Creating and using a SQLite tabl ......

railsʹÓÃsqlite3ºÍmysqlµÄÎÊÌâ

1¡¢Èç¹ûʹÓÃsqlite3ʱ³öÏÖÈçÏ´íÎó£º
/!\ FAILSAFE /!\  Thu Jul 30 22:16:15 +0800 2009
  Status: 500 Internal Server Error
  unknown error
    c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `initialize'
    c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `dlopen'
&nb ......

SQLiteÖеÄʱ¼äÈÕÆÚº¯Êý

SQLite°üº¬ÁËÈçÏÂʱ¼ä/ÈÕÆÚº¯Êý£º
datetime().......................²úÉúÈÕÆÚºÍʱ¼ä
date()...........................²úÉúÈÕÆÚ
time()...........................²úÉúʱ¼ä
strftime().......................¶ÔÒÔÉÏÈý¸öº¯Êý²úÉúµÄÈÕÆÚºÍʱ¼ä½øÐиñʽ»¯
datetime()µÄÓ÷¨ÊÇ£ºdatetime(ÈÕÆÚ/ʱ¼ä,ÐÞÕý·û,ÐÞÕý·û...) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ