SQLiteÈçºÎɾ³ý¡¢Ð޸ġ¢ÖØÃüÃûÁУ¿
Ê×ÏÈÉùÃ÷£ºÈç¹ûÄãÏëÖ±½Óalter£¬·ÅÆú°É¡£ÒÔÏÂÄÚÈÝ¿ÉÒÔºöÂÔÁË¡£
sqlite¹Ù·½ËµÃ÷ÈçÏ£º
SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows the user to rename a table or to add a new column to an existing table. It is not possible to rename a column, remove a column, or add or remove constraints from a table.
´ó¸ÅÒâ˼ÊÇsqliteµÄalter¹¦ÄÜÖ»ÊÇalter tableµÄÒ»¸ö×Ó¼¯£¬Ö»Óв¿·Ö¹¦ÄÜ£¬±ÈÈçÖØÃüÃû±íÃû£¬ÐÂÔöÁе½ÏÖÓбíÖС£
²»Ö§³ÖÏÖÓÐÁеÄÖØÃüÃû£¬É¾³ýºÍÐ޸ġ£
ÎÒÃÇÖ»ÄÜͨ¹ýÁÙʱ±íÀ´½â¾ö¡£
BEGIN TRANSACTION;
CREATE TEMPORARY TABLE temp_table(a);
INSERT INTO temp_table SELECT a from ±í;
DROP TABLE ±í;
CREATE TABLE ±í(a);
INSERT INTO ±í SELECT a from temp_table;
DROP TABLE temp_table;
COMMIT;
ÕâÑù¿ÉÒÔ½â¾ö£¬µ«ÊÇÈç¹ûÓÐ×ÔÔöÖ÷¼üµÄ»°£¬ÄǾÍҪСÐÄÁË¡£
Ïà¹ØÎĵµ£º
int column_names_printed = 0;
void print_row(int n_values, char** values)
{
int i;
for (i = 0; i < n_values; ++i) {
printf("%10s", values[i]);
}
printf("\n& ......
SQLiteÊý¾Ý¿âÁ¬½Ó·½Ê½
SQLite.NET
Type: .NET Framework Class Library
Usage: System.Data.SQLite.SQLiteConnection
Basic
Data Source=filename;Version=3;
Version 2 is not supported by this class library.
Using UTF16
Data Source=filename;Version=3;UseUTF16 ......
Step-1: Ê×ÏÈ將.mp3檔°¸·ÅÈëProjectµÄ/res/raw/裡£¬ÈçÏ£º
³Ìʽһ開ʼ執ÐУ¬½¨Á¢Ò»個資ÁÏ庫£¬º¬ÓÐBLOB欄룬ÈçÏÂÖ®Ö¸Á
sql ......
ÔÚ AndroidÖУ¬¶ÔÓÚÊý¾ÝµÄ´æÖü£¬Óм¸ÖÖ·½Ê½£¬ÓÐÎļþ·½Ê½£¬ÓÐÎļþʽÊý¾Ý¿â·½Ê½,Android×Ô´øÁËÒ»¸öSQLiteÊý¾Ý¿â£¬×öǶÈ뿪·¢µÄÈ˶ÔÕâ¸ö¿çƽ̨µÄ±¾µØÎļþÊý¾Ý¿âÒ»¶¨²»»áİÉú£¬ÔÚAndroid¶ÔÓÚÊý¾ÝµÄ·ÃÎÊ£¬Ìá³öÁËеķ½Ê½£¬ContentProvider·½Ê½£¬ÀàËÆÓÚMSµÄ ContentProvider·½Ê½µÄ£¬OLEDB£¬¼°ODBCͳһµÄÊý¾Ý·½Ê½¡£
ÎÒÃÇÊ×ÏÈÀ´¿´¿ ......