All Products
Search
Document Center

Tablestore:SQL query

Last Updated:Mar 08, 2025

This topic explains how to perform SQL query operations using the Tablestore PHP SDK.

Notes

Starting with version 5.1.0, the Tablestore PHP SDK includes support for the SQL query feature. Ensure you have the correct version of the PHP SDK installed to use this feature.

For more information, see the historical iterations of the PHP SDK.

Feature list

Operation

Description

Create mapping table

Create a mapping relationship for an existing table or index using the CREATE TABLE statement.

Update mapping table

Add or delete property columns for an existing mapping table using the ALTER TABLE statement.

Delete mapping table

Delete a mapping relationship using the DROP MAPPING TABLE statement.

List mapping tables

List the mapping tables in the current database using the SHOW TABLES statement.

Query table description

Query the description of a table, such as field names and field types, using the DESCRIBE statement.

Query index description

Query the index description of a table using the SHOW INDEX statement.

Query data

Query data in a table using the SELECT statement.