FMDB 新增字段

- (BOOL)updateOneBooktempID:(NSString *)bookid WithTable:(NSString*)tabName

{

    NSFileManager * fileManager = [NSFileManager defaultManager];

    NSString* filename = [self getDBPath];

    BOOL succ = NO;

    if ([fileManager fileExistsAtPath:filename])

    {

        

        FMDatabase *db = [FMDatabase databaseWithPath:filename];

        if ([db open])

        {

            //判断字段是否存在

            if ([db columnExists:BRA inTableWithName:tabName]) {

                NSString *update = [NSString stringWithFormat:@"UPDATE %@ SET bra = ? WHERE bookID = ?",tabName];

                succ =  [db executeUpdate:update,@"新增字段",bookid];

            }else{

                NSString *sql = [NSString stringWithFormat:@"ALTER TABLE %@ ADD %@ VARCHAR",tabName,@"bra"];

                [db executeUpdate:sql];

                NSString *update = [NSString stringWithFormat:@"UPDATE %@ SET bra = ? WHERE bookID = ?",tabName];

               succ =  [db executeUpdate:update,@"第一次新增字段",bookid];

            }

        }

        [db close];

    }

    return succ;

}