FMDatabase判断表是否存在

最新推荐文章于 2021-02-08 00:45:45 发布

乔布斯这个二货

最新推荐文章于 2021-02-08 00:45:45 发布

阅读量1.7k

点赞数

分类专栏： IOS数据库篇

IOS数据库篇专栏收录该内容

1 篇文章 0 订阅

订阅专栏

对于没得什么SQL基础的来说，弄起来还是很无助的，所以有就记录下把。

// 判断是否存在表

- (BOOL) isTableOK:(NSString *)tableName
{
    FMResultSet *rs = [self.DB executeQuery:@"select count(*) as 'count' from sqlite_master where type ='table' and name = ?", tableName];
    while ([rs next])
    {
        // just print out what we've got in a number of formats.
        NSInteger count = [rs intForColumn:@"count"];
        NSLog(@"isTableOK %d", count);

        if (0 == count)
        {
            return NO;
        }
        else
        {
            return YES;
        }
    }

    return NO;
}

简单扩展了下，方便自己使用。

BOOL isTableOK(FMDatabase *db,NSString * tableName)

{

FMResultSet *rs = [db executeQuery:@"select count(*) as 'count' from sqlite_master where type ='table' and name = ?", tableName];

while ([rs next])

{

// just print out what we've got in a number of formats.

NSInteger count = [rs intForColumn:@"count"];

NSLog(@"isTableOK %d", count);

if (0 == count)

{

return NO;