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