SQLite
SQLite https://simpholders.com/ –>可以在本機端裝DB http://sqlitebrowser.org/– >可以用SQlite的GUI https://github.com/ccgus/fmdb– >Xcode 的freamWork //建立資料表location create table location( longitude double NOT NULL , latitude double NOt NULL ) //宣告成為PRIMARY KEY id INTEGER NOT NILL PRIMARY KEY , //快速索引longitude欄位的資料 create index locationindex on location(longitude); create table location( longitude double NOT NULL , latitude double NOt NULL PRIMARY KEY (longitude,latitude)); ) insert insert into location( longitude, latitude ) values ( 5.4 , 5.533 ); update update location set longitude = 5.9654 , latitude = 5.8645 delete 整列刪掉 <br> delete from location where longitude = 5.9654 ; query select * from location; * =>every column select longitude from location; select longitude,latitude from location order by longitude asc ; 小於5.5 select longitude,latitude from location where longitude ...