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));