1、 表
CREATE TABLE map_group_ac (
gp_id integer,
ac_id varchar,
PRIMARY KEY(gp_id, ac_id)
);
2、 执行删除的语句
BOOL isCommit = YES;
NSNumber *numID = gp.ID; //gp.ID 是* NSNumber 的
isCommit = [shareDataBase executeUpdate: @"delete from map_group_ac where gp_id=?", numID];//不行 删不掉
NSNumberFormatter *numberFormatter = [[NSNumberFormatter alloc] init];
NSString* str = [numberFormatter stringFromNumber:numID];
isCommit = [shareDataBase executeUpdate: @"delete from map_group_ac where gp_id=?", str];//也不行 删不掉
3. 办法(这么写才删掉)
isCommit = [shareDataBase executeUpdateWithFormat:@"delete from map_group_ac where gp_id=%@", gp.ID];