全部产品
存储与CDN 数据库 安全 应用服务 数加·人工智能 数加·大数据基础服务 互联网中间件 视频服务 开发者工具 解决方案 物联网
分布式关系型数据库 DRDS

帮助语句

更新时间:2017-08-04 16:33:00

SHOW HELP 语句

展示 DRDS 所有辅助 SQL 指令及其说明。

  1. mysql> show help;
  2. +-----------------------------------------+---------------------------------------------------------+---------------------------------------------+
  3. | STATEMENT | DESCRIPTION | EXAMPLE |
  4. +-----------------------------------------+---------------------------------------------------------+---------------------------------------------+
  5. | show rule | Report all table rule | |
  6. | show rule from TABLE | Report table rule | show rule from user |
  7. | show full rule from TABLE | Report table full rule | show full rule from user |
  8. | show topology from TABLE | Report table physical topology | show topology from user |
  9. | show partitions from TABLE | Report table dbPartition or tbPartition columns | show partitions from user |
  10. | show broadcasts | Report all broadcast tables | |
  11. | show datasources | Report all partition db threadPool info | |
  12. | show node | Report master/slave read status | |
  13. | show slow | Report top 100 slow sql | |
  14. | show physical_slow | Report top 100 physical slow sql | |
  15. | clear slow | Clear slow data | |
  16. | trace SQL | Start trace sql, use show trace to print profiling data | trace select count(*) from user; show trace |
  17. | show trace | Report sql execute profiling info | |
  18. | explain SQL | Report sql plan info | explain select count(*) from user |
  19. | explain detail SQL | Report sql detail plan info | explain detail select count(*) from user |
  20. | explain execute SQL | Report sql on physical db plan info | explain execute select count(*) from user |
  21. | show sequences | Report all sequences status | |
  22. | create sequence NAME [start with COUNT] | Create sequence | create sequence test start with 0 |
  23. | alter sequence NAME [start with COUNT] | Alter sequence | alter sequence test start with 100000 |
  24. | drop sequence NAME | Drop sequence | drop sequence test |
  25. +-----------------------------------------+---------------------------------------------------------+---------------------------------------------+
  26. 20 rows in set (0.00 sec)
本文导读目录