sqlite操作失败 [复制链接]

sqlite中问题，如果数据库已经存在，那么不能进行插入，但是编译通过了是没问题的。
sqlite3 *db=NULL;
    char *zErrMsg = 0;
    int rc;
    rc = sqlite3_open("test1.db", &db);
    if( rc )
    {
      fprintf(stderr, "Can't open sqlite: %s\n", sqlite3_errmsg(db));
      sqlite3_close(db);
      exit(1);
    }
    else printf("open sqlite success\n");

    char *errMsg = NULL;
  
       int i = 0;
    for(i=0;i<10;i++)
    {
        char value[200];
        memset(value,0,200);
        sprintf(value, "INSERT INTO test(id,name) VALUES('%d','wang%d')",100+i,i);
        rc = sqlite3_exec(db,
                          value,
                          0, 0, &errMsg);
        if(rc == SQLITE_OK)
        {
            printf("insert one data success\n");
        }
        else
        {
            printf("insert one data failure\n");
        }
    }

    sqlite3_close(db);
}