FMDBのテスト.(http://www.slideshare.net/tomotsunemurata/sql-21454357)

test.m

#import "ViewController.h"
#import "FMDB.h" // FMDBのimport

@interface ViewController ()

@end

@implementation ViewController

- (void)viewDidLoad
{
    NSBundle *bundle = [NSBundle mainBundle];
    NSString *path2 = [bundle bundlePath];
    
    NSLog(@"test %@", path2);
    
    NSString *path = [path2 stringByAppendingString:@"/Data/Raw/test.db"];
    
    FMDatabase *db = [FMDatabase databaseWithPath:path];
    NSString *sql = @"CREATE TABLE IF NOT EXISTS test (user_id INTEGER PRIMARY KEY, user_name TEXT);";
    
    [db open];
    // [db setKey:@""];// 暗号化しているとき
    [db executeQuery:sql];
    [db close];
}

- (void)didReceiveMemoryWarning
{
    [super didReceiveMemoryWarning];
    // Dispose of any resources that can be recreated.
}

@end

http://obc-fight.blogspot.jp/2012/09/fmdb-basic-how-to-use.html