141      阿里云

删除数据__从 SQL 到 NoSQL_快速入门_表格存储-阿里云

SQL

关系型数据库中，可以使用 DELETE 语句从表中删除一个或多个行，如下所示：

DELETE FROM UserHistory 
    WHERE user_id = '10100' and time_stamp = 1479265526;

表格存储

使用表格存储时，可以使用 DeleteRow 接口一次删除一行数据，如下所示：

    // 设置主键
    PrimaryKeyBuilder primaryKeyBuilder = PrimaryKeyBuilder.createPrimaryKeyBuilder();
    primaryKeyBuilder.addPrimaryKeyColumn("user_id", PrimaryKeyValue.fromString("10100"));
    primaryKeyBuilder.addPrimaryKeyColumn("time_stamp", PrimaryKeyValue.fromLong(1479265526));
    PrimaryKey primaryKey = primaryKeyBuilder.build();
     RowDeleteChange rowDeleteChange = new RowDeleteChange(TABLE_NAME, primaryKey);
    // 删除该行数据
    client.deleteRow(new DeleteRowRequest(rowDeleteChange));