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

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
ÇëÎÊÔõô½â¾öÄØ

ÔÚÍøÉÏÕÒÔ´Â룬ȻºóÓÃ×Ô¼ºµÄ»·¾³±àÒ룬¾Í¿ÉÒÔÁË
{{


Ïà¹ØÎÊ´ð£º

ÓùýsqliteµÄÅóÓÑ¿´ÏÂ

×î¼òµ¥µÄÎÊÌâ¡£Ò²ÓеãÓôÃÆ¡£
ÎÒÏë´´½¨Ò»¸öÊý¾Ý¿â
ÎÒÏÖÔÚÖ»ÓÐÒ»¸ösqlite3.exeÎļþ¡£
ÎÒʹÓõķ½·¨ÊÇË«»÷Õâ¸öÎļþ
ʹÓõÄÃüÁîΪ£º
sqlite3 f:\a.db »Ø³µ
¿ÉÊǽá¹ûÈ´ÏÔʾΪ
  ...>
sqli ......

¡¾ÈçºÎ²é¿´SqliteÊý¾Ý¿âÖÐÓжàÉÙÕűí[¶¥ÕßÓзÖ]

SqlServerÖÐÕâÑùͳ¼Æ:

select name from sysobjects where xtype='U'
ÒªÖªµÀ×ÜÊýµÄ»°¾Í¼òµ¥ÁË£º
select count(*) from sysobjects where xtype='U'

OracleÖÐÕâÑù²éѯ£º
Sele ......

Sqlite intת»»ÎªÊ®Áù½øÖÆ

sqlliteÀïÃæÓÐʲô·½·¨°Ñintת»»ÎªÊ®Áù½øÖÆ´æ´¢µÄÄØ?
ÀýÈç,strftime('%s', 'now') µÃµ½1263777947,µ±Ç°µÄÃëÊý,ÎÒÏë´æ´¢ÎªËüµÄÊ®Áù½øÖƱíʾ"4B53B89B"
лл..

ÆäʵÎÒÊÇÏëstrftime ......

sqlite ×Ö¶ÎĬÈÏÖµµÈÓÚidÖµ

sqlite ÖÐ
CREATE TABLE table1 (
id integer primary key autoincrement,
name text default '',
[index] integer default ROWID
)

ÓÐûÓÐÀàËƵŦÄÜ£¬Èà index µÄֵĬÈϵÈÓÚid£¬ ......

sqlite dinstincÎÊÌâ

ΪʲôÓÃselect name,distinct phone from phone_book¾Í˵Óï·¨´íÎó£¬
      ÓÃselect distinct phone,name from phone_book¾Í¿ÉÒÔ£¿
ûÓÐΪʲô distinct ÊÇ select µÄÐÞÊηû£¬Ö»ÄÜÔÚ select ºóÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ