windowsÏÂsqlite°²×°Ê¹ÓúÍÐÔÄÜÓÅ»¯¼°ÉèÖÃ
ÔÎÄÁ´½Ó£ºhttp://edu.codepub.com/2008/1231/805.php
windowsÏÂsqlite°²×°Ê¹ÓúÍÐÔÄÜÓÅ»¯¼°ÉèÖÃ
sqliteÊÇǶÈëʽSQLÊý¾Ý¿âÒýÇæSQLite£¨SQLite Embeddable SQL Database Engine£©µÄÒ»¸öÀ©Õ¹¡£SQLiteÊÇÒ»¸öʵÏÖǶÈëʽSQLÊý¾Ý¿âÒýÇæÐ¡ÐÍCÓïÑԿ⣨C library£©£¬ÊµÏÖÁ˶ÀÁ¢µÄ£¬¿ÉǶÈëµÄ£¬ÁãÅäÖõÄSQLÊý¾Ý¿âÒýÇæ¡£ÌØÐÔ°üÀ¨£ºÊÂÎñ²Ù×÷ÊÇÔ×Ó£¬Ò»Ö£¬¹ÂÁ¢£¬²¢Çҳ־õ쬼´Ê¹ÔÚϵͳ±ÀÀ£ºÍµçÔ´¹ÊÕÏÖ®ºó¡£ ÁãÅäÖ×—²»ÐèÒª°²×°ºÍ¹ÜÀí¡£ÊµÏÖÁ˾ø´ó¶àÊýSQL92±ê×¼¡£Õû¸öÊý¾Ý¿â´æ´¢ÔÚÒ»¸öµ¥Ò»µÄÎļþÖС£Êý¾Ý¿âÎļþ¿ÉÒÔÔÚ²»Í¬×Ö½ÚÐòµÄ»úÆ÷Ö®¼ä×ÔÓɵع²Ïí¡£Ö§³Ö×î´ó¿É´ï2TµÄÊý¾Ý¿â¡£×Ö·û´®ºÍBLOBÀàÐ͵ĴóСֻÊÜÏÞÓÚ¿ÉÓÃÄÚ´æ¡£ÍêÕûÅäÖõÄÉÙÓÚ250KB£¬ºöÂÔһЩ¿ÉÑ¡ÌØÐÔµÄÉÙÓÚ150KB¡£ÔÚ´ó¶àÊý³£¼û²Ù×÷ÉϱÈÁ÷ÐеĿͻ§/·þÎñÆ÷Êý¾Ý¿âÒýÇæ¸ü¿ì¡£ ¼òµ¥Ò×ÓÚʹÓõÄAPI¡£ ÄÚ½¨TCL°ó¶¨¡£ ÁíÍâÌṩ¿ÉÓÃÓÚÐí¶àÆäËûÓïÑԵİ󶨡£¾ßÓÐÁ¼ºÃ×¢Ê͵ÄÔ´´úÂ룬´úÂë95%ÓнϺõÄ×¢ÊÍ¡£¶ÀÁ¢£ºÃ»ÓÐÍⲿÒÀÀµ¡£Ô´´úÂëλÓÚ¹«¹²Óò£¬¿ÉÓÃÓÚÈκÎÓÃ;¡£ÓÃSQLiteÁ¬½ÓµÄ³ÌÐò¿ÉÒÔʹÓÃSQLÊý¾Ý¿â£¬µ«²»ÐèÒªÔËÐÐÒ»¸öµ¥¶ÀµÄ¹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ½ø³Ì£¨separate RDBMS process£©¡£SQLite²»ÊÇÒ»¸öÓÃÓÚÁ¬½Óµ½´óÐÍÊý¾Ý¿â·þÎñÆ÷£¨big database server£©µÄ¿Í»§¶Ë¿â£¨client library£©£¬¶øÊǷdz£ÊʺÏ×ÀÃæ³ÌÐòºÍСÐÍÍøÕ¾µÄÊý¾Ý¿â·þÎñÆ÷¡£SQLiteÖ±½Ó¶Áд£¨reads and writes directly£©ÔÚÓ²ÅÌÉϵÄÊý¾Ý¿âÎļþ¡£
ÏÂÃæÊÇÎÒ×Ô¼ºµÄʹÓùý³Ì:
SQLite°²×°·½°¸
SQLiteµÄ×îа汾¿ÉÒÔ´ÓÕâÀïÏÂÔØ¡£ÏÂÃæÎÒÃÇÒÔWindows°æ±¾sqlite-3_5_1.zip ΪÀý½éÉÜÆä°²×°·½·¨¡£
£¨´ó¼Ò¿ÉÒÔÑ¡ÔñÏÂÔØ°²×°ÊʺÏ×Ô¼ºµÄ°æ±¾£©
ÏÂÔØºó£¬½«sqlite-3_5_1.zip½âѹËõÖÁC:\sqliteĿ¼¼´Íê³É°²×°¡£
C:\sqliteĿ¼¹¹ÔìΪ£º
C:\sqlite
|
+--sqlite3.exe
´ò¿ªÒ»¸öCMDÃüÁî´°¿Ú
C:\>cd sqlite
C:\sqlite>sqlite3.exe mydb.db
SQLite version 3.5.1
Enter ".help" for instructions
sqlite> create table user ( id integer primary key, name varchar(32) );
sqlite> .schema
CREATE TABLE user ( id integer primary key, name varchar(32) );
sqlite>.quit
Í˳öºó£¬²é¿´C:\sqliteĿ¼£¬»á·¢ÏÖ¶à³öÒ»¸ömydb.dbÎļþ£º
C:\sqlite
|
+--sqlite3.exe
+--mydb.db
SQLiteÐÔÄÜÓÅ»¯
ºÜ¶àÈËÖ±½Ó¾ÍʹÓÃÁË£¬²¢Î´×¢Òâµ½SQLiteÒ²ÓÐÅäÖòÎÊý£¬¿ÉÒÔ¶ÔÐÔÄܽøÐÐ
Ïà¹ØÎĵµ£º
SQLite Database Browser
SQLite Database browser is a light GUI editor for SQLite databases, built on top of Qt. The main goal of the project is to allow non-technical users to create, modify and edit SQLite databases using a set of wizards and a spreadsheet-like interface.
Downlo ......
2010ÄêSQLiteѧϰ±Ê¼ÇÖ®¶þ
Ò».½¨Á¢Êý¾Ý¿â
sqlite3.exe test.db
¶þ.Ë«»÷sqlite-3_6_16Ŀ¼ÏµijÌÐòsqlite3.exe£¬¼´¿ÉÔËÐÐ
Èý.Í˳ö
.exit
»òÕß
.quit
ËÄ.SQLiteÖ§³ÖÈçÏÂ5ÖÖÊý¾ÝÀàÐÍ
1.NULL£º¿ÕÖµ¡£
2.INTEGER£º´ø·ûºÅµÄÕûÐÍ£¬¾ßÌåÈ¡¾öÓдæÈëÊý×ֵķ¶Î§´óС¡£
3.REAL£º¸¡µãÊý×Ö£¬´æ´¢Îª8-byte IEEE¸¡µãÊý ......
SQLite3ÊÇSQLiteÒ»¸öȫеİ汾,ËüËäÈ»ÊÇÔÚSQLite 2.8.13µÄ´úÂë»ù´¡Ö®ÉÏ¿ª·¢µÄ,µ«ÊÇʹÓÃÁ˺Í֮ǰµÄ°æ±¾²»¼æÈݵÄÊý¾Ý¿â¸ñʽºÍAPI. SQLite3ÊÇΪÁËÂú×ãÒÔϵÄÐèÇó¶ø¿ª·¢µÄ:
Ö§³ÖUTF-16±àÂë.
Óû§×Ô¶¨ÒåµÄÎı¾ÅÅÐò·½·¨.
¿ÉÒÔ¶ÔBLOBs×ֶν¨Á¢Ë÷Òý.
Òò´ËΪÁËÖ§³ÖÕâÐ©ÌØÐÔÎҸıäÁËÊý¾Ý¿âµÄ¸ñʽ,½¨Á¢ÁËÒ»¸öÓë֮ǰ°æ±¾²»¼æÈݵ ......
1 TOP
ÕâÊÇÒ»¸ö´ó¼Ò¾³£Îʵ½µÄÎÊÌ⣬ÀýÈçÔÚSQLSERVERÖпÉÒÔʹÓÃÈçÏÂÓï¾äÀ´È¡µÃ¼Ç¼¼¯ÖеÄǰʮÌõ¼Ç¼£º
SELECT TOP 10 * from [index] ORDER BY indexid DESC;
µ«ÊÇÕâÌõSQLÓï¾äÔÚSQLiteÖÐÊÇÎÞ·¨Ö´Ðеģ¬Ó¦¸Ã¸ÄΪ£º
SELECT * from [index] ORDER BY indexid DESC limit 0,10;
ÆäÖÐlimit 0,10±íʾ´ÓµÚ0Ìõ¼Ç¼¿ªÊ¼£¬Íùºó ......