FMDB怎么使用

Question

db.execSQL("CREATE TABLE if not exists site_per_sms_info (" + "Id integer primary key autoincrement," + "AddTime datetime,"
                + "sid integer, " + "mypid integer, " + "SmsId integer, " + "FromPid integer,"
                + " importanttype integer, " + "Description varchar(4096)," + "picpath varchar(250)," + "CanAnswer integer,"
                + "ContentType integer," + "SmsType integer," + "RelationId integer," + "IsTop integer,"
                + "checkpid integer," + "IsSendSMS integer," + "ReadTag integer," + "ToPid integer)");
这段创建数据库的代码怎么使用fmdb添加到ios工程里面呀

Answer 1

去它github看看readme不就会了
把你的代码换进去就行了BOOL success = [db executeUpdate:@"INSERT INTO authors (identifier, name, date, comment) VALUES (?, ?, ?, ?)", @(identifier), name, date, comment ?: [NSNull null]];
if (!success) {
    NSLog(@"error = %@", [db lastErrorMessage]);
}

Answer 2

http://blog.csdn.net/w582324909/article/details/51984461

Answer 3

https://github.com/7General/FMDBFUNC