Help Center/ Distributed Database Middleware/ User Guide/ SQL Syntax/ Supported SQL Statements/ Specifying a Shard Using a Hint When Executing a SQL Statement
Updated on 2022-09-16 GMT+08:00
Specifying a Shard Using a Hint When Executing a SQL Statement
Command Format:
/*+db=<physical_db_name>*/ <your query>;
Description:
Specify a shard by configuring <physical_db_name> and execute a SQL statement on the shard.
Example:
/*+db=test_0000*/ select * from t1;
Restrictions:
- The hint is valid only for SELECT, DML, and TRUNCATE statements.
- The hint works only under the text protocol, rather than the Prepare protocol.
Parent topic: Supported SQL Statements
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
