如何使用FMDB从表中删除所有数据 [英] How to remove all data from table using FMDB

问题描述

我想从数据库中的表中删除所有数据.我正在使用FMDB.并且我已经使用了这段代码，但是它不会从我的表中删除数据.

I want to delete all data from table in my database. I am using FMDB.And i have used this code but it will not delete data from my table.

-(BOOL) deleteAll
{

    FMDatabase *db = [FMDatabase databaseWithPath:[Utility getDatabasePath]];
    [db open];

    BOOL success =  [db executeUpdate:@"TRUNCATE TABLE customers"];

    [db close];

    return success;
    return YES;
}

推荐答案

尝试使用此代码.

BOOL success =  [db executeUpdate:@"DELETE FROM customers"];

只要我知道Sqlite不支持 TRUNCATE 查询.

As long as i know Sqlite does not support TRUNCATE query.

这篇关于如何使用FMDB从表中删除所有数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！