SQL 语句记录

1.创建一个table @"create table rockTB(myId integer primary key autoincrement not null, time varchar(128) , body varchar(1024))"];

2.查询 

 FMResultSet * result = [sDB executeQuery:@"select * from rockTB"];

    while ([result next])

    {

        NSString * time = [result stringForColumn:@"time"];

        NSString * body = [result stringForColumn:@"body"];

        int myId = [result intForColumn:@"myId"];

        NSLog(@"time:%@ body:%@ myId:%d",time,body,myId);

    }

SQL 语句记录

原文：http://www.cnblogs.com/rollrock/p/4542506.html