Retro
Eye care
Haitian
Deep
Dark
Default
English
简体中文
1.
Overview
2.
Quick Start
2.1.
ShardingSphere-JDBC
2.2.
ShardingSphere-Proxy
3.
Concepts
3.1.
Adaptor
3.2.
Mode
3.3.
DistSQL
3.4.
Pluggable Architecture
4.
Features
4.1.
DB Compatibility
SQL Parser
MySQL
openGauss
PostgreSQL
SQLServer
Oracle
SQL92
DB Protocol
Feature Support
MySQL
PostgreSQL
SQLServer
Oracle
SQL92
4.2.
DB Gateway
4.3.
Cluster Management
Core Concept
4.4.
Sharding
Core Concept
Table
Data Node
Sharding
Inline Expression
Distributed Primary Key
Hint Sharding Route
Use Norms
SQL
Pagination
4.5.
Distributed Transaction
Core Concept
XA
BASE
Use Norms
Local Transaction
XA
BASE
4.6.
Readwrite-splitting
Core Concept
Use Norms
4.8.
Scaling
Core Concept
User Norms
4.9.
Encryption
Core Concept
Use Norms
4.10.
Shadow DB
Core Concept
Use Norms
4.11.
Observability
Core Concept
Use Norms
5.
User Manual
5.1.
ShardingSphere-JDBC
Java API
Mode Configuration
Data Source
Rules
Sharding
Readwrite-splitting
Encryption
Shadow DB
SQL Parser
Mixed Rules
YAML Configuration
Mode Configuration
Data Source
Rules
Sharding
Readwrite-splitting
Distributed Transaction
Encryption
Shadow DB
Mixed Rules
SQL-parser
JDBC Driver
Spring Boot Starter
Mode Configuration
Data Source
Rules
Sharding
Readwrite splitting
Encryption
Shadow DB
Mixed Rules
SQL Parser
Spring Namespace
Mode Configuration
Data Source
Rules
Sharding
Readwrite-splitting
Encryption
Shadow DB
SQL Parser
Mixed Rules
Properties Configuration
Builtin Algorithm
Metadata Repository
Sharding Algorithm
Key Generate Algorithm
Load Balance Algorithm
Encryption Algorithm
Shadow Algorithm
Special API
Sharding
Hint
Transaction
Use Java API
Use Spring Boot Starter
Use Spring Namespace
Atomikos Transaction
Bitronix Transaction
Narayana Transaction
Seata Transaction
Observability
Use Agent
APM Integration
Unsupported Items
5.2.
ShardingSphere-Proxy
Startup
Use Binary Tar
Use Docker
Use Helm
Yaml Configuration
Authority
Properties
Rules
DistSQL
Syntax
RDL Syntax
Resource Definition
Rule Definition
Sharding
Single Table
Readwrite-Splitting
DB Discovery
Encrypt
Shadow
RQL Syntax
Resource Query
Rule Query
Sharding
Single Table
Readwrite-Splitting
DB Discovery
Encrypt
Shadow
RAL Syntax
Usage
Sharding
Readwrite_splitting
Encrypt
DB Discovery
Shadow
Logging
Scaling
Build
Manual
5.3.
ShardingSphere-Sidecar
6.
Dev Manual
6.1.
Mode
6.2.
Configuration
6.3.
Kernel
6.4.
DataSource
6.5.
SQL Parser
6.6.
Proxy
6.7.
Data Sharding
6.8.
Readwrite-splitting
6.10.
Distributed Transaction
6.11.
Scaling
6.12.
SQL Checker
6.13.
Encryption
6.14.
Shadow DB
6.15.
Observability
7.
Reference
7.1.
Management
7.2.
Sharding
Parse Engine
Route Engine
Rewrite Engine
Execute Engine
Merger Engine
7.3.
Transaction
XA Transaction
Seata BASE transaction
7.4.
Scaling
7.5.
Encryption
7.6.
Shadow
7.7.
Test
Integration Test
Performance Test
Performance Test
Sysbench Test
Module Test
SQL Parser Test
SQL Rewrite Test
7.8.
FAQ
7.9.
API Change Histories
ShardingSphere-JDBC
YAML configuration
Java API
Spring namespace configuration change history
Spring Boot Starter Configuration
ShardingSphere-Proxy
7.10.
DistSQL
Syntax
RDL Syntax
Resource Definition
ADD RESOURCE
ALTER RESOURCE
DROP RESOURCE
Rule Definition
Sharding
CREATE SHARDING ALGORITHM
CREATE SHARDING TABLE RULE
CREATE DEFAULT SHARDING STRATEGY
CREATE SHARDING BINDING TABLE RULE
CREATE SHARDING BROADCAST TABLE RULE
CREATE SHARDING KEY GENERATOR
RQL Syntax
Resource Query
SHOW RESOURCE
SHOW UNUSED RESOURCE
SHOW USED RESOURCE
Rule Query
Sharding
SHOW SHARDING TABLE RULE
RAL Syntax
Reserved word
8.
Downloads
Download PDF
ShardingSphere
>
User Manual
>
ShardingSphere-Proxy
>
DistSQL
>
Syntax
>
RQL Syntax
> Rule Query
This chapter describes the syntax of rule query.
Previous
Next