Óùý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ÉÏÖ´ÐУ¿
Ïà¹ØÎÊ´ð£º
1¡¢juliandayÕâ¸öº¯ÊýÖ»ÓдøÉÏÄê·Ý¼ÆËã²Å¿É¿¿£»
2¡¢ÎÒÄ¿Ç°Óõķ½·¨SELECT £¨jolianday(¡®now¡¯)-jolianday(¡®1981-12-23¡¯)£©%365
3¡¢Õâ¸ö·½·¨¿Ï¶¨ÓÐÎÊÌ⣬µ«ÊµÔÚ²»ÖªµÀÔõôʵÏÖ£»
Òò´ËÏ£Íû¸÷λÈÊÐÖ°ï°ïæ£ ......
ÈçÌ⣬ûÓÐÖ÷¼ü£¬ÎÒֻҪɾ³ýÇ°NÌõ¼Ç¼¡£nÊýÖµ´ó¸ÅÔÚǧÍò¼¶±ðµÄ¡£
ûÓÐÖ÷¼ü
ÓÐûÓÐÆäËü¿É¹©ÅÅÐòµÄ×ֶΣ¿
SQL code:
delete from tb where id in (select top n id from tb)
ÒýÓÃ
ûÓÐÖ÷¼ü
......
mdb.execDML(L"insert into faultcode values('stu.szNumber', 'stu.szName','stu.szReason', 'stu.szStep')");
ÎÒÏë°Ñ½á¹¹Ìå±äÁ¿stu.szNumberÖеÄÄÚÈÝ´æ´¢µ½Êý¾Ý ......
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 Ö»ÓÐ7K £¬ÊDz»ÄÜÓõÄÎļþ£¬ÎªÊ²Ã´»áÕâÑù£¿£¿
±àÒë¹ý³Ì£¿¿ÉÄÜij¸öÔ¤´¦Àí¿ª¹ØûÉèÖúã¬Ã»Óе¼³öº¯Êý¡£
ÓÐÒ»¸ösqlite3.def ÎļþÎÒ°ÑËüÍϵ½¹¤³ÌÀïÒ»Æð±àÒ룬ÕâÑùÐв»£¿ÒªÔõÑùÉèÖã¬ÎÒ¶ÔBC ²»Êì ......