Sqlite³£Óú¯Êý£º
ÎÄÕÂÀ´Ô´ÓÚhttp://blog.csdn.net/ast_224/archive/2009/01/08/3734099.aspx
Sqlite
³£Óú¯Êý£º
1
¡¢´ò¿ªÊý¾Ý¿â£º
˵Ã÷£º´ò¿ªÒ»¸öÊý¾Ý¿â£¬ÎļþÃû²»Ò»¶¨Òª´æÔÚ£¬Èç¹û´ËÎļþ²»´æÔÚ£¬
sqlite
»á×Ô¶¯´´½¨¡£µÚÒ»¸ö²ÎÊýÖ¸ÎļþÃû£¬µÚ¶þ¸ö²ÎÊýÔòÊǶ¨ÒåµÄ
sqlite3 **
½á¹¹ÌåÖ¸Õ루¹Ø¼üÊý¾Ý½á¹¹£©£¬Õâ¸ö½á¹¹µ×²ãϸ½ÚÈçºÎ£¬Äú²»ÓùÜËü¡£
int sqlite3_open(
const char *filename,
/*
Database filename (UTF-8) */
sqlite3 **ppDb
/* OUT:
SQLite db handle */
);
·µ»ØÖµ£º±íʾ²ÙËùÊÇ·ñÕýÈ·
£¨
SQLITE_OK
²Ù×÷Õý³££©
2
¡¢¹Ø±ÕÊý¾Ý¿â£º
˵Ã÷£ºÈç¹ûÓÃ
sqlite3_open
¿ªÆôÁËÒ»¸öÊý¾Ý¿â£¬½áβʱ²»ÒªÍüÁËÓÃÕâ¸öº¯Êý¹Ø±ÕÊý¾Ý¿â¡£
int sqlite3_close(s
Ïà¹ØÎĵµ£º
ÎÄÕ·ÖÀà:Êý¾Ý¿â
SQLiteÔÚVCϵÄʹÓã¨×ª£©http://www.sqlite.com.cn/MySqlite/4/523.Html
Ò»¡¢SQLite¼ò½é
SQLite
ÊÇÓÃCÓïÑÔ±àдµÄ¿ªÔ´Êý¾Ý¿â£¬Ö÷ÒªÓÃÓÚǶÈëʽ£¬ÄãÒ²¿ÉÒÔ°ÑËü¼¯³ÉÔÚ×Ô¼ºµÄ×ÀÃæ³ÌÐòÖУ¬Ò²ÓÐÈ˽«ÆäÌæ´úAccess£¬ÓÃ×÷ºǫ́Êý¾Ý¿â¡£
SQLite Ö§³Ö¶àÊýSQL92 ......
Ò»¡¢SQLite¼ò½é
SQLite ÊÇÓÃCÓïÑÔ±àдµÄ¿ªÔ´Êý¾Ý¿â£¬Ö÷ÒªÓÃÓÚǶÈëʽ£¬ÄãÒ²¿ÉÒÔ°ÑËü¼¯³ÉÔÚ×Ô¼ºµÄ×ÀÃæ³ÌÐòÖУ¬Ò²ÓÐÈ˽«ÆäÌæ´úAccess£¬ÓÃ×÷ºǫ́Êý¾Ý¿â¡£
SQLite Ö§³Ö¶àÊýSQL92±ê×¼£¬ÀýÈ磺Ë÷Òý¡¢ÏÞÖÆ¡¢´¥·¢ºÍ²é¿´Ö§³Ö¡£
Ö§³Ö NULL¡¢INTEGER¡¢REAL¡¢TEXT ºÍ BLOB Êý¾ÝÀàÐÍ£¬Ö§³ÖÊÂÎñ¡£
¶þ¡¢ÏÂÔØSQLite
SQLite¿ÉÒÔµ½¹Ù·½Õ ......
sqliteʱ¼äº¯Êý£¨×ª£©
2007Äê12ÔÂ10ÈÕ ÐÇÆÚÒ» 13:33
תÌùÔÒò£º×î½üÉè¼ÆÁËÒ»¸ö¿çÊý¾Ý¿âµÄº¯Êý£¬À´²âÊÔ²âÊÔsqlite¡£
SQLite·ÖÒ³ÏÔʾ£ºSelect * from news order by id
desc Limit 10 Offset 10
ÕâÆªÎÄÕÂÊǸù¾Ý SQLite ¹Ù·½ WIKI ÀïµÄÄÚÈÝ·Ò룬Èç¹ûÓÐʲô·Òë²»µ±µÄµØ·½Ï£Íû´ó¼ÒÖ¸³ö£¬±Ï¾¹ÎÒµÄÓ¢ÎÄˮƽʵÔںܲ SQ ......
1. ÏÂÔØ×îаæ SQLite (sqlite-3_6_23_1), copyµ½C:\ÏÂ.
2. н¨Êý¾Ý¿â:
C:\>sqlite3.exe "d:\testdb.db"
3.½øÈëÁËsqlite3Ö®ºó£¬»á¿´µ½ÒÔÏÂÎÄ×Ö£º
SQLite version 3.1.3
Enter ".help" for instructions
sqlite>
4.½¨Ò»¸öÃû½ÐfilmµÄÊý¾Ý¿â±í
create table film(title, length, year, starring);
5.²åÈë¼Ç¼ ......
ÓÃÁËADO.NET 2.0 SQLite Data Provider ÕâÑù¿ÉÒÔÖ±½ÓÀûÓÃËüÀ´´´½¨Ò»¸ö¼ÓÃܵÄsqliteÊý¾Ý¿â¡£
ÓйØc#´úÂëÈçÏ£º
1¡¢´´½¨¿ÕµÄsqliteÊý¾Ý¿â¡£
//Êý¾Ý¿âÃûµÄºó׺Äã¿ÉÒÔÖ±½ÓÖ¸¶¨£¬ÉõÖÁûÓкó׺¶¼¿ÉÒÔ
//·½·¨Ò»£º´´½¨Ò»¸ö¿ÕsqliteÊý¾Ý¿â£¬ÓÃIOµÄ·½Ê½
FileStream fs = File.Create(“c:\\test.db“);
//·½·¨¶þ£ºÓ ......