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

ÓùýSQLiteµÄÅóÓѺÍÍæ¹ýÅú´¦ÀíµÄÅóÓѽøÀ´¿´Ò»ÏÂ.


    żÏ뱸·ÝÊý¾Ý±í£¬Ð´ÁËÒ»¸öÅú´¦Àí£¬ÓÐÏֳɵÄÊý¾Ý¿â¡£µ«ÊÇÅú´¦Àíдµ½Ò»°ë²»»áÁË£¬»¹Çë°ïæ¿´¿´£¬ÔõôÍùÏ¡£¡£¡£

    @echo off
    echo ÕýÔÚϵͳÊý¾Ý¿â±¸·Ý£¬ÇëÉÔµÈ......
    sqlite3.exe digitalcity.db  //ÐèÒª±¸·ÝµÄÊý¾Ý¿â
    sqlite>.output tmp.sql    //ÕâÒ»²¿·Ö²»¶Ô¡£¡£µ«²»ÖªµÀÔõôȥд¸üºÏÊÊ¡£
    sqlite>.dump              //ÕâÒ»²¿·Ö²»¶Ô¡£¡£µ«²»ÖªµÀÔõôȥд¸üºÏÊÊ¡£
    sqlite>.quit              //ÕâÒ»²¿·Ö²»¶Ô¡£¡£µ«²»ÖªµÀÔõôȥд¸üºÏÊÊ¡£

   

      sqlite3 mynew.sqlite3      //Ä¿±êÊý¾Ý¿â
      sqlite>.read tmp.sql      //ÕâÒ»²¿·Ö²»¶Ô¡£¡£µ«²»ÖªµÀÔõôȥд¸üºÏÊÊ¡£
      sqlite>.quit              //ÕâÒ»²¿·Ö²»¶Ô¡£¡£µ«²»ÖªµÀÔõôȥд¸üºÏÊÊ¡£

    echo ±¸·ÝÍ껪£¬°´ÈÎÒâ¼ü½áÊø£¡
    echo. & pause


    °ï¸öæллÀ²£¡£¡£¡

     

ÔÚMobileÉÏÖ´ÐУ¿


Ïà¹ØÎÊ´ð£º

sqlite »ñÈ¡×î½üÉúÈÕÓû§µÄ·½·¨£¿

1¡¢juliandayÕâ¸öº¯ÊýÖ»ÓдøÉÏÄê·Ý¼ÆËã²Å¿É¿¿£»
2¡¢ÎÒÄ¿Ç°Óõķ½·¨SELECT £¨jolianday(¡®now¡¯)-jolianday(¡®1981-12-23¡¯)£©%365
3¡¢Õâ¸ö·½·¨¿Ï¶¨ÓÐÎÊÌ⣬µ«ÊµÔÚ²»ÖªµÀÔõôʵÏÖ£»
Òò´ËÏ£Íû¸÷λÈÊÐÖ°ï°ïæ£ ......

ÈçºÎÔÚsqliteÖÐɾ³ýÇ°NÌõ¼Ç¼

ÈçÌ⣬ûÓÐÖ÷¼ü£¬ÎÒֻҪɾ³ýÇ°NÌõ¼Ç¼¡£nÊýÖµ´ó¸ÅÔÚǧÍò¼¶±ðµÄ¡£
ûÓÐÖ÷¼ü

ÓÐûÓÐÆäËü¿É¹©ÅÅÐòµÄ×ֶΣ¿

SQL code:
delete from tb where id in (select top n id from tb)

ÒýÓÃ
ûÓÐÖ÷¼ü

......

ÈçºÎ½«±äÁ¿ÖеÄÊý¾Ý´æ´¢µ½SQLiteÊý¾Ý¿âÖÐ

mdb.execDML(L"insert into faultcode values('stu.szNumber', 'stu.szName','stu.szReason', 'stu.szStep')");

ÎÒÏë°Ñ½á¹¹Ìå±äÁ¿stu.szNumberÖеÄÄÚÈÝ´æ´¢µ½Êý¾Ý ......

SqliteÎÞ·¨¸üÐÂ

C# code:
public static bool UpdateFriendUrl(int id, string cnName, string jpName, string logoUrl, string site, int order)
{
string sql = "update FriendUrl set SiteNameCN=@SiteNameC ......

BC ±àÒë³öµÄSqlite DLL Ϊʲô²»Õý³£

BC Éú³ÉµÄSqlite DLL Ö»ÓÐ7K £¬ÊDz»ÄÜÓõÄÎļþ£¬ÎªÊ²Ã´»áÕâÑù£¿£¿
±àÒë¹ý³Ì£¿¿ÉÄÜij¸öÔ¤´¦Àí¿ª¹ØûÉèÖúã¬Ã»Óе¼³öº¯Êý¡£

ÓÐÒ»¸ösqlite3.def ÎļþÎÒ°ÑËüÍϵ½¹¤³ÌÀïÒ»Æð±àÒ룬ÕâÑùÐв»£¿ÒªÔõÑùÉèÖã¬ÎÒ¶ÔBC ²»Êì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ