sqlite

import data to table from csv file:

1. sqlite3 testDatabase

create database testDatabase

2. create table testTable(name String primary key, job String);

3. .mode csv

4. .import ./test.csv testTable

5. select * from testTable;

show content of testTable

6. drop table testTable;

delete testTable

support sqlite in project:

(1)add framework

framework location:

/Developer/Platforms/iPhoneOS.plateform/Developer/SDKs/iPhoneOS2.2.1.sdk/usr/lib/libsqlite3.0.dylib

(2) import "/usr/include/sqlite3.h"