Wish list: Support SHOW TABLES IN as allowed in MySQL

[ryanmasse]

[yakirgb]

You already have: show tables from monitor;

proxysql001:admin> show tables from monitor;
+--------------------------------------+
| tables                               |
+--------------------------------------+
| mysql_server_aws_aurora_check_status |
| mysql_server_aws_aurora_failovers    |
| mysql_server_aws_aurora_log          |
| mysql_server_connect_log             |
| mysql_server_galera_log              |
| mysql_server_group_replication_log   |
| mysql_server_ping_log                |
| mysql_server_read_only_log           |
| mysql_server_replication_lag_log     |
+--------------------------------------+
9 rows in set (0.00 sec)

[ryanmasse]

@yakirgb you are 100% correct. The point being MySQL supports both SHOW TABLES [IN | FOR]. Just wishful thinking for guys like me who has been using SHOW TABLES IN for 15 years who gets frustrated having to remember to context switch. :)

[renecannao]

Breaking an habit after 15 years is difficult!
Improvement added in 2.0.9 .
Thanks