After a table is created, you can read data from and write data to the table in the console.

Add data

  1. Log on to the Tablestore console.
  2. On the Overview page, click the name of the target instance or click Manage Instance in the Actions column.
  3. In the Table List section of the Instance Details tab, click the name of the target table and click the Data Editor tab. You can also click Data Editor in the Actions column.
  4. On the Data Editor tab, click Insert.
  5. In the Insert dialog box that appears, set Primary Key Value. Click Add Column. Set Name, Type, Value, and Version.
    By default, System Time is selected, indicating that the current system time is used as the version number of the data. You can also clear System Time and enter the version number of the data.
  6. Click OK.
    Rows that contain the written data are displayed on the Data Editor tab.
    Note A maximum of 50 rows of data can be displayed in the console. However, Tablestore does not impose limits on the number of rows of data that can be displayed when you use Tablestore SDK.

Delete data

You can delete data you no longer need.

  1. Log on to the Tablestore console.
  2. On the Overview page, click the name of the target instance or click Manage Instance in the Actions column.
  3. In the Table List section of the Instance Details tab, click the name of the target table and click the Data Editor tab. You can also click Data Editor in the Actions column.
  4. On the Data Editor tab, select the row of data to delete. Click Delete.
  5. In the Delete message that appears, click OK.

Update data

You can update data in the attribute columns of a row.

  1. Log on to the Tablestore console.
  2. On the Overview page, click the name of the target instance or click Manage Instance in the Actions column.
  3. In the Table List section of the Instance Details tab, click the name of the target table and click the Data Editor tab. You can also click Data Editor in the Actions column.
  4. On the Data Editor tab, select the row of data to delete. Click Update.
    fig_tablestore_004
  5. In the Update dialog box that appears, modify the type and value for the primary key, add or remove attribute columns, and update or delete data in attribute columns.
    • You can click +Add Column to add an attribute column. You can also click the fig_tablestore_005 icon to delete an attribute column.
    • If you select Update, you can modify data in attribute columns. If you select Delete, select the number of version to delete. If you select Delete All, all versions of the data are deleted.
  6. Click OK.

Query data

In the Tablestore console, you can query data in a single row (GetRow) or query data within a specified range (RangeQuery).

To query data in a single row, perform the following operations:

  1. Log on to the Tablestore console.
  2. On the Overview page, click the name of the target instance or click Manage Instance in the Actions column.
  3. In the Table List section of the Instance Details tab, click the name of the target table and click the Data Editor tab. You can also click Data Editor in the Actions column.
  4. On the Data Editor tab, click Search.
  5. Set basic filter conditions.
    1. Set Modes to GetRow.
      fig_tablestore_006
    2. By default, all columns are returned. To return a specific attribute column, turn off Columns to Return, and then enter the specified attribute columns. Separate the attribute columns with commas(,).
      Note You can specify a maximum of 20 attribute columns in the console. This limit does not apply to Tablestore SDK.
    3. Set Primary Key Value.
      The integrity and accuracy of the primary key value affect the query results.
    4. Set Count of Versions to specify the maximum number of versions to return.
  6. Click OK.
    Data that meets the filter conditions is displayed on the Data Editor tab.

To perform range query, perform the following steps:

  1. Log on to the Tablestore console.
  2. On the Overview page, click the name of the target instance or click Manage Instance in the Actions column.
  3. In the Table List section of the Instance Details tab, click the name of the target table and click the Data Editor tab. You can also click Data Editor in the Actions column.
  4. On the Data Editor tab, click Search.
  5. Set basic filter conditions.
    1. Set Modes to Range Search.
      fig_tablestore_007
    2. By default, all columns are returned. To return a specific attribute column, turn off Columns to Return, and then enter the specified attribute columns. Separate the attribute columns with commas(,).
      Note You can specify a maximum of 20 attribute columns in the console. This limit does not apply to Tablestore SDK.
    3. Set Start Primary Key Column and End Primary Key Column.
      You can set Start Primary Key Column to Min Value or Custom and End Primary Key Column to Max Value or Custom. If you select Custom, enter a custom value.
      Note
      • The value in the first primary key column takes priority when the range query mode is used. When the minimum and maximum values for the first primary key column are the same, the system uses the value in the second primary key column to perform the query. The query rules for the subsequent primary keys are the same as those for the first two primary keys.
      • The Custom range is a left-open and right-closed interval.
    4. Set Count of Versions to specify the maximum number of versions to return.
    5. Set Sequence to Forward Search or Backward Search.
  6. Click OK.
    Data that meets the filter conditions is displayed based on the specified order on the Data Editor tab.