SQLITE´æÍ¼Æ¬
´ó¼ÒºÃ£¬ÇëÎʸ÷λ´óϺ£¬ËÓÐSQLITE´æÍ¼Æ¬Â·¾¶µÄ´úÂë»òÀý×Ó°¡£¬Çë°ïæ¸øÐ¡µÜ·¢Ò»¸ö£¬tiandaliubin@163.com ÕæµÄºÜ¼±°¡¡£ÏÈллÁË¡£
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
ÕâÀïÄĸöÊÇ´æÍ¼Æ¬µÄ°¡£¬Ó¢ÎIJ»ÊǺܺã¬Äܲ»ÄÜ˵µÄÇå³þÒ»µã
http://www.sqlite.com.cn/MySqlite/3/132.Html
aaa
°ÑͼƬÎļþÒÔ¶þ½øÖÆÊý¾ÝµÈ·½Ê½´æÈësqlite£¬¶ÁÈ¡³öÀ´ºó£¬ÔÙת»»³ÉͼƬ
blob×ֶοÉÒÔ´æ´¢¶þ½øÖÆÊý¾Ý
ͬÎÊ£¬ÎÒÒ²ÏëÖªµÀ£¬ÎÒÊǰÑͼƬÊý¾Ý´æ½øÈ¥µÄ£¬blob×ֶΣ¬ÇëÎÊoyljerry ÄãËù˵µÄ¶Á³öÀ´×ª»»µÈµÈ£¬ÔÚÄÄÀï¿ÉÒÔÕÒµ½²Î¿¼Ê¾ÀýÂð »òÊÇÄÄÀïÓн²½âÂð£¿
ллÀ²~
¶ÁÈ¡³öÀ´ºó£¬ÔÙת³ÉͼƬ¡£Õâ²½Äܲ»ÄÜ˵µÄÏêϸһЩ£¬ÔõÑù²ÅÄÜת»»³ÉͼƬ£¿
Ïà¹ØÎÊ´ð£º
¸üÐÂÓï¾äÖУº
UPDATE sc SET AA=INT(BB)
ÎÒÏëÈÃAAµÃµ½BBµÄÕûÊýÖµ¡£¿ÉÊÇÔËÐб¨´í¡£
²»ÖªµÀSQLiteÏ ȡÕûÊý²¿·ÖµÄº¯ÊýÊÇÄĸö£¿£¨ËÄÉáÎåÈëµÄº¯ÊýÓÖÊÇÄĸö£¿£©¡£
Èç¹ûÖªµÀ»¹ÓÐÆäËûº¯ÊýÇëÒ»²¢¸æÖª£¬Ð»Ð»¡£
ROUND
......
ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éÑ¯Ê ......
¹ØÓÚjuliandayº¯ÊýµÄÎÊÌ⣬ÎÒÏÖÔÚ±íAÖÐÒ»¸ö×Ö¶Îbʱ¼äÀàÐÍ£¬ÈçºÎbΪ½ñÌìµÄÊý¾Ý£¿Ð»Ð»
select * from ±íÃû where datediff(d,getdate(),×Ö¶Îb)=0 ÕâÑùÄã¿´Ðв»£¿
ÎÒÓõÄÊÇsqliteÊý¾Ý¿â£¬Ëü²»Ö§³ÖdatediffµÄ¡ ......
±ÈÈ磺
1¡¢Á¬½ÓÊý¾Ý¿â£»
2¡¢½¨±í£¬insert ¡¢update,delete,selectÈçºÎд£¿
ÊDz»ÊÇÒªÏÂÔØ ADO.NET 2.0 ÒýÇæ£¿
sqliteʹÓÃÊÖ²á
ллqshurufa£¬ÎÒÏëÖªµÀÈçºÎͨ¹ývb.netʵÏÖ£¬¾ÍÊÇÓï¾äզд£¿
Dim Conn As New ......
¸Õѧsqlite£¬´´½¨Á˸ö±í£¬Í˳ösqliteÓÖÖØÐ´ò¿ªºó£¬²éѯ˵ûÓÐÕâ¸ö±í¡£ÔõôÑù²ÅÄܱ£´æÕâ¸ö±íÄØ£¬windowsÏÂ
Ö±½ÓÔËÐÐsqlite3.exe,È»ºó¾Í¾ÍÖ±½Ócreate table TestÁË
Í˳ösqlite3.exe ÖØÐ´ò¿ª£¬select¾ÍÌáʾûÓÐÕâ ......