SQLite 3 һЩ»ù±¾Ê¹ÓÃ
	
    
    
	ʹÓù¤¾ß£º  
      SQLite Expert SQLiteÊý¾Ý¿â¹ÜÀí¹¤¾ß£¬·Ç³£ºÃÓã¬ÀàËÆÎÒ֮ǰ½éÉܵÄEMS SQL Manager 2007 for MySQL 
      System.Data.SQLite SQLite For ADO.NETÇý¶¯,ÀàËÆÎÒ֮ǰ½éÉܵÄMySql.Data.dll 
Õâ2¸ö¹¤¾ß¶¼°üÀ¨ÁËSQLiteµÄÒýÇæ 
1¡¢´Óhttp://www.sqlite.org/ÏÂÔØSQLite 3.3.4µÄ°æ±¾ 
      ΪÁË·½±ã£¬ÎÒ°ÑËü½âѹÁË£¬¾ÍÒ»¸öSQLite3.exe£¬·ÅÈëWindowsĿ¼Ï¡£ 
      Cmd ½øÈëÃüÁîÐÐ 
      1) ´´½¨Êý¾Ý¿âÎļþ: 
            >SQLite3 d:\test.db »Ø³µ 
            ¾ÍÉú³ÉÁËÒ»¸ötest.dbÔÚdÅÌ¡£ 
            ÕâÑùͬʱҲSQLite3¹ÒÉÏÁËÕâ¸ötest.db 
      2) ÓÃ.help¿ÉÒÔ¿´¿´ÓÐʲôÃüÁî 
            >.help »Ø³µ¼´¿É 
      3)´´½¨±í¸ñ 
            ¿ÉÒÔÔÚÕâÀïÖ±½ÓÊäÈëSQLÓï¾ä´´½¨±í¸ñ¡£ÓÃ;½áÊø£¬È»ºó»Ø³µ¾Í¿ÉÒÔ¿´µ½ÁË 
      4)¿´¿´Óд´½¨Á˶àÉÙ±í 
            >.tables 
      5)¿´±í½á¹¹ 
            >.schema ±íÃû 
      6)¿´¿´Ä¿Ç°¹ÒµÄÊý¾Ý¿â 
            >.database 
      7)Èç¹ûÒª°Ñ²éѯÊä³öµ½Îļþ 
            >.output ÎļþÃû 
            > ²éѯÓï¾ä£» 
            ²éѯ½á¹û¾ÍÊä³öµ½ÁËÎļþc:\query.txt 
      8)°Ñ²éѯ½á¹ûÓÃÆÁÄ»Êä³ö 
        &nb
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    Õâ¶Îʱ¼äÔÚ×öCMS£¨¿Í»§¹ÜÀíϵͳ£¬²»ÊÇÄÚÈݹÜÀí£©µÄ·ÃÎʹÜÀí¹¦ÄÜ£¬ÒªÇóʵÏÖ¶Ô·þÎñÌṩÉ豸£¬¿Í»§¶Ë£¬¼Æ·Ñ£¬È¨ÏÞÈÏÖ¤µÈÐÅÏ¢µÄ´æ´¢Í³¼Æ£¬Ô¶³Ì¹ÜÀí¡£ÒªÇóϵͳ·¢²¼Òª·½±ã£¬Ô¶³Ì¹ÜÀíÈí¼þÒªÅÜÔÚWINƽ̨¡£¿¼Âǵ½ÏµÍ³¹æÄ££¬¿Í»§ÒªÇó£¬×îºóÑ¡ÔñÁËWIN+ACCESSµÄ·½°¸£¬¶ø×î½üÓÖ·¢ÏÖÒ»¸öÃâ·ÑµÄSQLITE£¬¶øÇÒ¿ÉÄÜÔÚÒÔºóµÄÊÖ³ÖÉ豸ÉÏÓ㬻¨µã ......
	
    
        
    
    backup ?DB? FILE ±¸·ÝÊý¾Ý¿âµ½Îļþ£¬Ä¬Èϱ¸·ÝµÄÊÇmainÊý¾Ý¿â,Èç¹û²»¸½¼ÓÊý¾Ý¿â£¬test.dbÎļþÖÐĬÈϵÄÖ»ÓÐmainÊý¾Ý¿â¡£ ÃüÁî²Ù×÷¾ÙÀý£º 
sqlite> .backup mydb.bak
sqlite>
´Ëʱ¿ÉÒÔÔÙFÅÌ¿´µ½mydb.bakÎļþ£¬ÓüÇʱ¾´ò¿ªËäÈ»ÊÇÂÒÂ룬µ«¿É¿ú¼ûÒ»°ß¡£ 
.restore ?DB? FILE ´Ó±¸·ÝÎļþ»¹ÔÊý¾ÝºÍ.backupÏà¶ÔÓ¦. ½ÓÉÏ ......
	
    
        
    
    Ò»¡¢SQLite¼ò½é
SQLite ÊÇÓÃCÓïÑÔ±àдµÄ¿ªÔ´Êý¾Ý¿â£¬Ö÷ÒªÓÃÓÚǶÈëʽ£¬ÄãÒ²¿ÉÒÔ°ÑËü¼¯³ÉÔÚ×Ô¼ºµÄ×ÀÃæ³ÌÐòÖУ¬Ò²ÓÐÈ˽«ÆäÌæ´úAccess£¬ÓÃ×÷ºǫ́Êý¾Ý¿â¡£
SQLite Ö§³Ö¶àÊýSQL92±ê×¼£¬ÀýÈ磺Ë÷Òý¡¢ÏÞÖÆ¡¢´¥·¢ºÍ²é¿´Ö§³Ö¡£
Ö§³Ö NULL¡¢INTEGER¡¢REAL¡¢TEXT ºÍ BLOB Êý¾ÝÀàÐÍ£¬Ö§³ÖÊÂÎñ¡£
¶þ¡¢ÏÂÔØSQLite
SQLite¿ÉÒÔµ½¹Ù·½Õ¾µ ......
	
    
        
    
    CnGuiDB.js
var db : dbAccess; 
public var  mskin : GUISkin;
private var mstring : String;
	var inputStr;
function Start(){ 
inputStr = "1";
}
function search(mid)
{
   db = new dbAccess(); 
   db.OpenDB("db1.db"); 
   var tableName = "myTable"; 
   // table name, I want to return everyo ......
	
    
        
    
          ½üÀ´ÒòΪ¹¤×÷ÐèÒª¼ÓÈësqlite ´¦ÀíÊý¾Ý£¬ÏÂÔØÁËsqlite3.6.22(amalgamation °æ±¾£©£¬ÓÖÏë×Ô¼º¶¯ÊÖ±àÒë³öÀ´Ï붯̬Á´½Ó¾Í¶¯Ì¬£¬Ï뾲̬Á´½ÓÒ²¿ÉÒÔ£¬ÓÚÊÇÓÐÁËÕâÆªÎÄÕ£¬ÓÐÒâ˼µÄÊÇ֮ǰҲÊÔ¹ý±àÒëSqlite£¬µ«Ã»³É¹¦£¬²»ÁËÁËÖ®£¬¿ÉÄܽüÀ´Òª¹ýÄêÁË
¸ú
RPÓйذÉ:)¡£
1 Ê×ÏÈ´´½¨vs2008µÄÒ»¸ö¿ÕDLL¹¤³Ì;
2 ......