首页 > itarticle > ios–sqlite同时删除多张表写法

ios–sqlite同时删除多张表写法

admin 11月 12, 2020 0

把删除多张表的语句写在同一句sql语句里

NSString *sql = [NSString stringWithFormat:
                    @"delete from LFFloors where deleteId = '%@';"
                    "delete from LFUnit where deleteId = '%@';"
                    "delete from LFLayer where deleteId = '%@';"
                    "delete from LFHouse where deleteId = '%@';",deleteId,deleteId,deleteId,deleteId];