建表时增加判断 :
if (![db columnExists:@"增加的属性" inTableWithName:@"表名"]) {
NSString *alertStr = [NSString stringWithFormat:@"ALTER TABLE 表名 ADD 字段属性 varchar"];
create = [db executeUpdate:alertStr];
}
if (create) {
NSLog(@"数据库建表成功");
}
建表时增加判断 :
if (![db columnExists:@"增加的属性" inTableWithName:@"表名"]) {
NSString *alertStr = [NSString stringWithFormat:@"ALTER TABLE 表名 ADD 字段属性 varchar"];
create = [db executeUpdate:alertStr];
}
if (create) {
NSLog(@"数据库建表成功");
}
转载于:https://my.oschina.net/u/2603560/blog/1580291