fmdb中常用的sqlite語句

fmdb資料庫語句

select:

SELECT * FROM table WHERE condition = ? ORDER BY condition ASC LIMIT startNum,count

其中: ORDER BY ------ ASC 升序   DESC 降序

 LIMIT --------------- startNum 起始位置  count 個數

update

UPDATE table SET condition WHERE condition

insert

INSERT INTO table(condition1,condition2) VALUES(?,?)

delete

DELETE FROM table where condition

create

CREATE TABLE IF NOT EXISTS table(column1,column2)