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

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

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


ÆäʵÎÒÊÇÏëstrftime('%s', 'now')²îÉúµÄÃëÊýºÍrandomblob²úÉúÒ»¸öËæ»úÊý×éºÏ×÷ΪID,ÓÃÊ®Áù½øÖÆÀ´±£´æÊÇΪÁ˽ÚÊ¡¿Õ¼ä,×÷ΪID×Ö¶ÎĬÈÏÖµ,×Ô¶¯²úÉú,Èç¹ûÓóÌÐòÔÙ´¦ÀíÓе㲻̫ºÃŪÁË.

ËäÈ»¿ÉÒÔͨ¹ý²éѯÀ´ÊµÏÖÕâÖÖת»»µ«Ð§ÂÊ»á±È½Ï²î£¬²¢ÇÒÒÆÖ²ÐÔ²»ºÃ¡£

лл´ó¼ÒÁË..


Ïà¹ØÎÊ´ð£º

ʹÓ÷ÉÐÅÐéÄâ.net»·¾³£¬ÔÚʹÓÃSQLiteʱΪʲô±¨´íÄØ

C# code:

System.Data.SQLite.SQLiteConnection conn = new SQLiteConnection(@"acs.db");
try
{
conn.Open();
}
......

c#Á¬½ÓSqliteÊý¾Ý¿âÎÊÌâ

ÎÒÓÃsqliteadmin½¨ÁËÒ»¸öÊý¾Ý¿âtest.sdb,¿ÉÊÇÔõôҲ´ò²»¿ªÌáʾÈçÏ´íÎó£ºFile opened that is not a database file
file is encrypted or is not a database¡£

ÎÒµÄÁ¬½Ó×Ö·û´®ÈçÏÂÂ¥ÉϵĿɲ»¿ÉÒÔ°ïÎÒ¿´¿´
S ......

sqlite ²éѯijһÊý¾ÝËùÔÚµÄÐÐÊý

sqlite ²éѯijһÊý¾ÝËùÔÚµÄÐÐÊý£º

ÆäÖÐÊý¾Ý±íÖÐûÓÐרÃűêʶÌõÊýµÄË÷ÒýÖµ£¬ÎÒÃǸù¾ÝÆäËûһЩ×ֶβéÕÒµ½Á˸ÃÊý¾Ý£¬ÏÖÔÚÐèÒª·µ»Ø¸ÃÊý¾ÝËùÔÚµÄÐÐÊý¡£

ÆäÖÐsqlite manager ÖÐÓÐÒ»¸örowid£¬µ«ÊÇÕâ¸ö²¢ÎÞ·¨· ......

sqliteµÄ¿ÕÖµ²éѯÔõôд,ÄÜÕߵ÷Ö

sqliteµÄ¿ÕÖµ²éѯÔõôд,ÄÜÕߵ÷Ö
select * from tt where f1 is null

select * from yourTable where col is null;

SQL code:
sqlite> create table Aoqun (id int primary key,col1 int);
sqlite> ......

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

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