SQLITEµÄ¾ÖÏÞÐÔ
SQLiteºÍÆäËû´ó²¿·ÖÏÖ´úSQLÊý¾Ý¿âÔÚ»ù±¾Éè¼ÆÄ¿±êÉÏÊDz»Í¬µÄ£¬ËüµÄÄ¿±êÊǼòµ¥¡£SQLite×ñÑÕâһĿ±ê£¬¼´Ê¹ÕâÑùż¶û»áµ¼ÖÂijЩÌØÐÔʵÏֵĵÍЧ»¯¡£ÏÂÃæÁоÙÁËSQLiteµÄһЩȱÏÝ£º
SQL-92ÌØÐÔ·½Ãæ
ÕýÈçÇ°ÃæÌáµ½µÄ£¬SQLite²»Ö§³ÖSQL-92µÄÔںܶàÆóÒµÊý¾Ý¿âϵͳÖпÉÓõÄһЩÌØÐÔ¡£
È磺
Íâ¼üÔ¼Êø£¨¿É½âÎöµÄ£¬µ«·ÇÇ¿ÖÆ£©
ºÜ¶àALTER TABLEÌØÐÔ
һЩTRIGGERÏà¹ØµÄÌØÐÔ
RIGHTºÍFULL OUTER JOIN
¸üÐÂÒ»¸öVIEW
GRANTºÍREVOKE
Äã¿ÉÒÔÔÚSQLiteµÄÖ÷Ò³ÉÏ»ñÈ¡×îÐÂÐÅÏ¢¡£
http://www.sqlite.org/omitted.html
http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql
µÍ²¢·¢²Ù×÷
SQLiteÖ»Ö§³ÖƽÃæÊÂÎñ£»ËüûÓÐǶÌ׺ÍÓª¾ÈµãÄÜÁ¦¡£Ç¶Ì×Òâζ×ÅÔÚÒ»¸öÊÂÎñÖпÉÒÔÓÐ×ÓÊÂÎñµÄÄÜÁ¦¡£Óª¾ÈµãÔÊÐíÒ»¸öÊÂÎñ·µ»Øµ½Ç°ÃæÒѾµ½´ïµÄ״̬¡£ËüûÓÐÄÜÁ¦È·±£¸ß²ã´ÎÊÂÎñµÄ²¢·¢¡£ËüÔÊÐíÔÚµ¥¸öµÄÊý¾Ý¿âÎļþÉ϶à¸ö²¢·¢µÄ¶ÁÊÂÎñ£¬µ«ÊÇÖ»ÄÜÓÐÒ»¸öÅÅËûµÄдÊÂÎñ¡£Õâ¸ö¾ÖÏÞÐÔÒâζ×ÅÈç¹ûÓÐÊÂÎñÔÚ¶ÁÊý¾Ý¿âÎļþµÄÒ»²¿·Ö£¬ËùÓÐÆäËûµÄÊÂÎñ½«±»½ûֹд¸ÃÎļþµÄÈκÎÒ»²¿·Ö¡£ÀàËƵģ¬Èç¹ûÓÐÊÂÎñÔÚдÊý¾Ý¿âÎļþµÄÒ»²¿·Ö£¬ËùÓÐÆäËûÊÂÎñ½«±»½ûÖ¹¶Á»òÕßд¸ÃÎļþµÄÈκÎÒ»²¿·Ö¡£
Ó¦ÓÃÏÞÖÆ
ÒòΪËüÊÂÎñ´¦ÀíµÄÓÐÏÞ²¢·¢£¬SQLiteÖ»Éó¤´¦ÀíСÐ͵ÄÊÂÎñ¡£ÔںܶàÇé¿öÏ£¬Õâ²»ÊÇÎÊÌ⡣ÿ¸öÓ¦ÓÃѸËÙµÄÍê³ÉËüµÄÊý¾Ý¿â¹¤×÷È»ºó¼ÌÐøÇ°½ø£¬Òò´ËûÓÐÒ»¸öÊÂÎñ»á³ÖÓÐÊý¾Ý¿â³¬¹ý¶àÉÙºÁÃë¡£µ«ÊÇÔÚһЩӦÓÃÖУ¬ÌرðÊÇдÈëÃܼ¯µÄ£¬ÒªÇó¸ü¶àµÄ²¢·¢µÄÊÂÎñ´¦Àí£¨±í»òÕßÐ춱ðµÄ¶ø²»ÊÇÊý¾Ý¿â¼¶±ðµÄ£©ÄÇôÄ㽫ҪΪ¸ÃÓ¦ÓÃʹÓÃÆäËû²»Í¬µÄDBMS¡£SQLite²¢²»´òËã³ÉΪһ¸öÆóÒµDBMS¡£Ëû×îÊʺÏÓÚʵÏÖ£¬Î¬»¤ºÍ¹ÜÀíµÄ¼òµ¥ÐÔ±ÈÉÌÒµÊý¾Ý¿âµÄÎÞ¾¡¸´ÔÓÌØÐÔ¸üΪÖØÒªµÄÇé¿ö¡£
NFSÎÊÌâ
SQLiteʹÓñ¾µØÎļþËøÔÓïÀ´¿ØÖÆÊÂÎñ´¦ÀíµÄ²¢·¢ÐÔ¡£Èç¹ûÊý¾Ý¿âÎļþפÁôÔÚÍøÂç·ÖÇøÉÏ£¬¿ÉÄܻᵼÖÂÎļþËø²»Äܹ¤×÷¡£ºÜ¶àµÄNFSʵÏÖ±»ÈÏΪÔÚËüÃǵÄÎļþËøÖÐÊÇÓÐbugµÄ£¨ÔÚUnixºÍWindowsÉÏ£©¡£Èç¹ûÎļþËø²»ÄÜÏñÔ¤¼ÆµÄÒ»Ñù¹¤×÷£¬ÄÇô¾Í¿ÉÄÜ»áÓÐÁ½¸ö»òÁ½¸öÒÔÉϵÄÓ¦ÓóÌÐòÔÚͬʱÐÞ¸ÄÏàͬÊý¾Ý¿âµÄͬһ²¿·Ö£¬µ¼ÖÂÁËÊý¾Ý¿âµÄ»Ù»µ¡£ÒòΪÕâ¸öÎÊÌâµÄ³öÏÖÊÇÒòΪλÓÚϲãµÄÎļþϵͳµÄʵÏÖµÄBUG£¬ËùÒÔSQLiteûÓа취×èÖ¹ËüµÄ·¢Éú¡£
ÁíÒ»ÔÒòÊÇ´ó¶àÊýÍøÂçÎļþϵͳµÄÁ¬½ÓÑÓʱ£¬Ð§¹û²»ÊǺܺá£ÔÚÕâÖÖ»·¾³Ï£¬ÔÚÊý¾Ý¿âÎļþ±ØÐëÒª¿çÍøÂç·ÃÎʵÄÇé¿öÏ£¬ÊµÏÖÁË¿Í»§¶Ë-·þÎñÆ÷µÄÄ£Ð͵ÄDBMS»á±ÈSQLite¸üÓÐЧ¡£
Êý¾Ý¿â¹æÄ£
ÒòΪËüµÄ¿ª·¢ÈËÔ±µÄ¿ª·¢Éè¼ÆÑ¡Ôñ£¬SQLite¿ÉÄܲ»ÊÇÒ»¸ö×ö·Ç³£´óÐ͵ÄÊý¾
Ïà¹ØÎĵµ£º
QT¶ÁдSqliteÊý¾Ý¿â
//.h
/****************************************************************************
**
** Date : 2010-05-08
** Author : furtherchan
** If you have any questions , please contact me
**
****************************************************************** ......
AutoIt3¿ª·¢µÄ²Ù×÷SQliteÊý¾Ý¿âµÄÔ´ÂëÏÂÔØ
²¿·ÖÔ´Âë
_SQLite_Startup () ;¼ÓÔØ SQLite.dll
If Not FileExists($SQLite_Data_Path) Then
SQLCreate()
EndIf
$GUI_Form = GUICreate($Title, 300, 435, -1, -1)
GUISetBkColor(0xECE9D8) ; will change background color
$GUI_ListBox = GUIC ......
package com.jiao.sqlite;
import android.app.Activity;
import android.database.Cursor;
import android.os.Bundle;
import android.view.KeyEvent;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widg ......
ÔÚ .NET ÀïÃæʹÓà SQLite£¬ ÎÒÕâÀïʹÓõÄwrapperÊÇ System.Data.SQLite£¬ËüÖ»ÐèÒªÒ»¸ödll,½Ó¿Ú·ûºÏADO.Net 2.0µÄ¶¨Òå,ÐÔÄÜÒ²²»´í,NHibernateÓõÄÒ²ÊÇËü£¬Ä¿Ç°Ö§³ÖADO.NET 3.5ÁË£¬Ö§³Ö¼¯³ÉÔÚ VS2005 ºÍ VS2008ÀïÃ棬¶øÇÒÖ§³Öwince£¬ÊǸöÁÁµã
ÒòΪ·ûºÏADO.NETµÄ¹æ·¶£¬ËùÒÔʹÓ÷½Ê½£¬»ù±¾ºÍ SqlClient, OleDbµÈÔÉúµÄÒ»ÖÂ
us ......
1. ÏÂÔØ×îаæ SQLite (sqlite-3_6_23_1), copyµ½C:\ÏÂ.
2. н¨Êý¾Ý¿â:
C:\>sqlite3.exe "d:\testdb.db"
3.½øÈëÁËsqlite3Ö®ºó£¬»á¿´µ½ÒÔÏÂÎÄ×Ö£º
SQLite version 3.1.3
Enter ".help" for instructions
sqlite>
4.½¨Ò»¸öÃû½ÐfilmµÄÊý¾Ý¿â±í
create table film(title, length, year, starring);
5.²åÈë¼Ç¼ ......