FMDB

1. Import FMDB files to user xcode
2. import libsqlite3.0.dylib

.h

FMDB *fmdb;

.m

fmdb = [FMDB alloc]init];

/**
 * Open Database
 **/

[fmdb open];
  
 [fmdb executeUpdate:@"create table  USER (name text)"];


[fmdb beginTransaction];
   
/**
 * Insert Data
 **/


 [fmdb executeUpdate:@"insert into USER (name) values (?);",@"ravi"];
   
 [fmdb commit];




/**
 * Reteriview Data
 **/

FMResultSet *results = [fmdb executeQuery:@"SELECT * FROM USER;"];
  
    while ([results next]) {
       
  NSLog(@"name %@ ",[results stringForColumn:@"name"]);
      
    }
   [fmdb close];