Sqlite·µ»Ø¶à½á¹û¼¯ÎÊÌâ
Sqlite·µ»Ø¶à¸ö²éѯ½á¹û¼¯µÄʱºò£¬ÓÐʲô°ì·¨ÄÜÒÆ¶¯µ½ÏÂÒ»¸ö½á¹û¼¯ÉÏÈ¥
±ÈÈç
ÓÐÓï¾ä
select * from sqlite_master where type='table';select * from sqlite_master where type='index';
Õâ¸öÓï¾äÖ´ÐÐÆðÀ´£¬¾Í»á·µ»ØÁ½¸ö½á¹û¼¯
ÇëÎÊÓÐûÓÐÌṩAPIº¯ÊýÔÚÁ½¸ö½á¹û¼¯Çл»µÄ£¿
²»ÊÇÓõÄADO,¾ÍÊÇÓõÄSqlite×Ô¼ºµÄdll¿â
Õâ¸ö¿ÉÒÔÖ´ÐжàÌõÓï¾ä°¡£¬Ö»ÒªÓ÷ֺŷָî¾Í¿ÉÒÔÁË£¬ÓÃsqlite3.exeÖ´ÐÐÁ½Ìõ¶¼ÐУ¬Ö»ÊÇËû°ÉÁ½ÌõÓï¾äµÄÁ½¸ö½á¹û¼¯×ۺϷµ»ØÁË¡£
²»ÖªµÀÕâλ˵µÄ recordsets[0], recordset[1]£¬ÔõÑùÓã¡ÇëÏêÊö£¬Ð»Ð»
ÎÒÊÇÓõÄDelphi£¬ÓõÄZeosLib¿Ø¼þ×飬Õâ¸ö¶«Î÷Ò²ÊÇÓõÄSqliteµÄ¿ª·ÅAPI½Ó¿ÚʵÏֵģ¡ÀïÃæÓÐTZQuery;
query: TZQuery;
begin
query := TZQuery.create(nil);
query.con := ZConnection;
query.sql.add('select * from sqlite_master where type=''table'';');
query.sql.add('select * from sqlite_master where type=''index''; ');
query.open;
end;
ÄãÓá¡ZeosLib£¬Ó¦¸Ã²éѯһÏÂZeosLibµÄ°ïÖú¡£
ÎÊÌâÒѾ¸ã¶¨£¬£¡½á
Ïà¹ØÎÊ´ð£º
ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éÑ¯Ê ......
ÎÒ°²×°ÁËÒ»¸ösqlite developer,Ò»¸ö¿ÉÊÓ»¯µÄ¹¤¾ß¡£
½Ó×Å£¬ÎÒÓÖ°²×°ÁËSQLite.NET,²¢ÔÚVSÀïÃæÌí¼ÓºÃÁËdll¡£
ÏÖÔÚ£¬ÎÒÔÚsqlite developerÀï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬¿âÖаüº¬ÎÒ×Ô¼º¶¨ÒåµÄÒ»ÕÅ±í¡£
ÎÊÌ⣺ÈçºÎ ......
ÄǸö¸ßÊÖ½Ó´¥¹ýsqlite£¬·¢µã¶ÔsqliteµÄÏêϸԴÂë·ÖÎö£¬Ð»Ð»~~
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÒýÓÃ
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÓÐûÓÐһЩ¹ØÓÚSQLiteÄÚ´æ·ÖÅä· ......
¸Õѧsqlite£¬´´½¨Á˸ö±í£¬Í˳ösqliteÓÖÖØÐ´ò¿ªºó£¬²éѯ˵ûÓÐÕâ¸ö±í¡£ÔõôÑù²ÅÄܱ£´æÕâ¸ö±íÄØ£¬windowsÏÂ
Ö±½ÓÔËÐÐsqlite3.exe,È»ºó¾Í¾ÍÖ±½Ócreate table TestÁË
Í˳ösqlite3.exe ÖØÐ´ò¿ª£¬select¾ÍÌáʾûÓÐÕâ ......