dadrobna/distributed-database-middleware
1
0
Fork 0
forked from docs/distributed-database-middleware
Code Pull Requests Activity
distributed-database-middle.../umn/source/sql_syntax/database_management_syntax.rst
proposalbot 78ac771d84 Changes to ddm_umn from docs/doc-exports#613 (DDM UMN 1st version 
DDM UMN 1st v

Reviewed-by: Wagner, Fabian <fabian.wagner@t-systems.com>
Co-authored-by: proposalbot <proposalbot@otc-service.com>
Co-committed-by: proposalbot <proposalbot@otc-service.com>
2024-01-08 13:37:20 +00:00

4.0 KiB
Raw Permalink Blame History

original_name

ddm_03_0032.html

Database Management Syntax

Supported Database Management Syntax

  • SHOW Syntax

  • SHOW COLUMNS Syntax

  • SHOW CREATE TABLE Syntax

  • SHOW TABLE STATUS Syntax

  • SHOW TABLES Syntax

  • SHOW DATABASES

    If the required database is not found, check fine-grained permissions of your account.

  • SHOW INDEX FROM

  • SHOW VARIABLES Syntax

Supported Database Tool Commands

  • DESC Syntax

  • USE Syntax

  • EXPLAIN Syntax

    Unlike EXPLAIN in MySQL, the output of DDM EXPLAIN describes the nodes that the current SQL statement is routed to.

Unsupported Database Management Syntax

Table 1 Restrictions on database management statements
Item Restriction
Database management statements
  • Executing SET Syntax to modify global variables is not supported.
  • SHOW TRIGGERS is not supported.

The following SHOW statements are randomly sent to a database shard. If database shards are on different RDS for MySQL instances, the returned variables or table information may be different.

  • SHOW TABLE STATUS
  • SHOW VARIABLES Syntax
  • CHECK TABLE does not support sharding tables by hash or sharding key.
  • SHOW WARNINGS Syntax does not support the combination of LIMIT and COUNT.
  • SHOW ERRORS Syntax does not support the combination of LIMIT and COUNT.