sqliteÒÆÖ²wince
ÎÒÏëÔÚpdaÉÏÓÃSQLiteÊý¾Ý¿â£¬ÎÒ³ÌÐòÊÇqtдµÄ£¬µ«ÊÇÎÒÓ¦¸ÃÔõÑù½«SQLiteÒÆÖ²µ½winceƽ̨ÉÏÄØ£¬ÎÒÏÖÔÚÓÐÁËSQLite.dllºÍSQLite.lib£¬Ö®ºóÎÒ½»²æ±àÒëÉú³ÉÁË.exeÎļþ£¬ÎªÊ²Ã´ÔÚÄ£ÄâÆ÷Éϲ»ÄÜÔËÐÐÄØ£¿
ÆÚ´ýןßÊֻشð£¬Ð»Ð»ÁË
ÍøÉÏÓÐwince°æ±¾£¬±ðÈ˱àÒëºÃµÄ¡£
ÕÒһϣ¬¿ÉÒÔÓõġ£ÎÒÓùý
ÎÒÔÚÖ´ÐÐ.exeÎļþºó
´´½¨¿â
sqlite>sqilte3 test.db
...>create table foo(id integer);
È»ºó¾Í±¨ÁËÏÂÃæµÄ´íÎó
Error:near "sqlite3":syntax error
ÇëÎÊÔõô½â¾öÄØ
ÔÚÍøÉÏÕÒÔ´Â룬ȻºóÓÃ×Ô¼ºµÄ»·¾³±àÒ룬¾Í¿ÉÒÔÁË
{{
Ïà¹ØÎÊ´ð£º
ÔÚvs2005ÖÐÒýÓÃÁËusing System.Data.SQLite;
¶¨ÒåÁËÒ»¸öÁ¬Êý¾Ý¿âÁ¬½Ó±äÁ¿public SQLiteConnection dBConn;
¾Í±¨ÏÂÃæÕâ¸ö´íÎóÁË.
The type 'System.Data.Common.DbConnection' is defined in an ass ......
sqliteÖÐÓÐûÓжÔÓÚÊý¾Ý¿â´óС½øÐйÜÀíµÄ½Ó¿Ú£¿±ÈÈ磬´´½¨Êý¾Ý¿âµÄʱºòÖ¸¶¨Êý¾Ý¿â´óС£¬¶ÔÊý¾Ý¿â½øÐвÙ×÷ºó²ì¿´¸ÃÊý¾Ý¿âÊ£ÓàµÄ¿ÉʹÓõĿռä´óСµÈ¡£×î½ü¿´ÁËÒ»ÏÂsqliteµÄÏà¹Ø½Ó¿Ú£¬ÍøÉÏÒ²ËÑË÷ÁËÏ£¬Ã»ÓÐÕÒµ½ÓÐÓõÄ×Ê ......
sqlite ÖÐ
CREATE TABLE table1 (
id integer primary key autoincrement,
name text default '',
[index] integer default ROWID
)
ÓÐûÓÐÀàËÆµÄ¹¦ÄÜ£¬Èà index µÄֵĬÈϵÈÓÚid£¬ ......
´ó¼ÒºÃ, ÉÏÀñ°ÝÓÐÀ´ÎÊ˵ÈçºÎ´ÓlinuxÉÏ·ÖÏí³ösqliteµÄdbÊý¾ÝÈÃwindows²Ù×÷, ºóÀ´Ò»Ö±ÎÞ·¨Ö±½Ó͸¹ýip·½Ê½Äõ½µµ°¸, Ïë˵¸ÄÓÃftp·½Ê½¶ÁµµÐ´Èëºó, ÔÙÉÏ´«»Ølinux server, ÏÖÔÚÓиöÎÊÌâµ±win pc¿ªÆôdbµµ°¸ºó, ºÃÏñ»áËø×¡Ë ......
ΪʲôÓÃselect name,distinct phone from phone_book¾Í˵Óï·¨´íÎó£¬
ÓÃselect distinct phone,name from phone_book¾Í¿ÉÒÔ£¿
ûÓÐΪʲô distinct ÊÇ select µÄÐÞÊηû£¬Ö»ÄÜÔÚ select ºóÖ ......