6. --SQLite 专属的修改

//根据名字来修改年龄

-(void)changeStudentAge:(NSInteger)age withName:(NSString *)name

{

    NSString *changeSQL = [NSString stringWithFormat:@"UPDATE 'student' SET age = %ld WHERE name = '%@' ",age,name];

    

    int result = sqlite3_exec(db, changeSQL.UTF8String, NULL, NULL, NULL);

    

    if (SQLITE_OK == result) {

        NSLog(@"修改成功");

    }

    else

    {

        NSLog(@"修改失败");

    }

}