Sqlite3³£ÓÃSQLÓï¾ä×ܽᣬһÊÇ·ÀÖ¹×Ô¼ºÍüÁË£¬¶þÊÇ·ÖÏí

ÎÄÖеÄSQL¶¼ÊÇ´ÓÎÒµÄÏîÄ¿ÖÐÖ±½Ócopy¹ýÀ´£¬Òò´ËºÜ¶à±íÃûʲô¶¼ÓÐÁË
//´´½¨±í
"CREATE TABLE FEED_TABLE(FeedID TEXT, Title TEXT, Summary TEXT, Author TEXT, ImageName VARCHAR(21), ImageType TEXT, MaxIndex INT, ImageData BLOB)"
//²éѯ¼Ç¼
"select * form 'table_name'"
"select * form 'table name' where value = '?'"
//²åÈë¼Ç¼
"INSERT INTO FEED_TABLE(FeedID, Title, Summary, ImageName, ImageType, MaxIndex) VALUES('%s', '%s', '%s', '%s', '%s', %d)"
//¸üмǼ
"update 'table_name' 'column_name' = 'value'"
//ɾ³ý¼Ç¼
"DELETE from FAVORITE_TABLE WHERE EntryIndex = %d"
//ɾ³ýËùÓмǼ
"delete from 'table_name'"
//ɾ³ý±í
"drop table 'table_name'"
//²éѯ±í½á¹¹
"select sql from sqlite_master where name = 'table_name'"
callbackµÄµÚÈý¸ö²ÎÊý
ÁíÍâ,sqlite3ÊÇÖ§³ÖÊÂÎñµÄ
int result;
result = sqlite3_exec( db, "begin transaction", 0, 0, &zErrorMsg ); //¿ªÊ¼Ò»¸öÊÂÎñ
result = sqlite3_exec( db, "commit transaction", 0, 0, &zErrorMsg ); //Ìá½»ÊÂÎñ
result = sqlite3_exec( db, "rollback transaction", 0, 0, &zErrorMsg ); //»Ø¹öÊÂÎñ