510      阿裏雲

寫入數據__從 SQL 到 NoSQL_快速入門_表格存儲-阿裏雲

SQL

關係型數據庫中，表是一個由行和列組成的二維數據結構，可以使用 INSERT 語句向表中添加行，如下所示：

INSERT INTO UserHistory (
    user_id, time_stamp, item_id, behavior_type,
    behavior_amount, behavior_count, content)
VALUES(
    '10100', 1479265526, 'cell_phone', 'share', 4.9, 78,
    'The phone is quit good!'
);

表格存儲

使用表格存儲時，可以使用 PutRow 接口插入一行數據，如下所示：

    // 設置主鍵
    PrimaryKeyBuilder primaryKeyBuilder = PrimaryKeyBuilder.createPrimaryKeyBuilder();
    primaryKeyBuilder.addPrimaryKeyColumn("user_id", PrimaryKeyValue.fromString("10100"));
    primaryKeyBuilder.addPrimaryKeyColumn("time_stamp", PrimaryKeyValue.fromLong(1479265526));
    PrimaryKey primaryKey = primaryKeyBuilder.build();
    // 設置屬性列的值
    RowPutChange rowPutChange = new RowPutChange(TABLE_NAME, primaryKey);
    rowPutChange.addColumn(new Column("item_id", ColumnValue.fromString("cell_phone")));
    rowPutChange.addColumn(new Column("behavior_type", ColumnValue.fromString("share")));
    rowPutChange.addColumn(new Column("behavior_amount", ColumnValue.fromDouble(4.9)));
    rowPutChange.addColumn(new Column("behavior_count", ColumnValue.fromLong(78)));
    rowPutChange.addColumn(new Column("content", ColumnValue.fromString("The phone is quit good!")));
    // 插入該行數據
    client.putRow(new PutRowRequest(rowPutChange));