You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
MySQL supports SHOW XXXX from [table] or SHOW FULL XXX from [table] to query information_schema, for example:
SHOW FULL TABLES WHERE Table_type !='VIEW'
SHOW TABLE STATUS
SHOW PROCEDURE STATUS where DB='public';
SHOW INDEX FROM`monitor`;
SHOW FULL COLUMNS from`monitor`;
We have to support these syntax sugars if we want to improve the compatibility of MySQL protocol.
Tasks:
Refactor show tables and show databases executor, make them querying from information_schema and support where clause such as SHOW FULL TABLES WHERE Table_type != 'VIEW'. refactor: show tables and show databases #3423
SHOW CHARACTER SET
SHOW COLLATION
SHOW COLUMNS
SHOW DATABASES
SHOW FUNCTION STATUS
SHOW INDEX
SHOW OPEN TABLES
SHOW PROCEDURE STATUS
SHOW STATUS
SHOW TABLE STATUS
SHOW TABLES
SHOW TRIGGERS
SHOW VARIABLES
killme2008
changed the title
Show syntax sugar for information_schema
Show statement extensions for information_schema tables
Mar 3, 2024
killme2008
changed the title
Show statement extensions for information_schema tables
Extensions to SHOW Statements for information_schema tables
Mar 3, 2024
What type of enhancement is this?
API improvement, User experience
What does the enhancement do?
MySQL supports
SHOW XXXX from [table]
orSHOW FULL XXX from [table]
to query information_schema, for example:We have to support these syntax sugars if we want to improve the compatibility of MySQL protocol.
Tasks:
show tables
andshow databases
executor, make them querying frominformation_schema
and supportwhere
clause such asSHOW FULL TABLES WHERE Table_type != 'VIEW'
. refactor: show tables and show databases #3423show columns
feat: impl show index and show columns #3577show table status
show index
feat: impl show index and show columns #3577SHOW CHARACTER SET
feat: impl show collation and show charset statements #3753SHOW COLLATION
feat: impl show collation and show charset statements #3753show variables
.Implementation challenges
No response
The text was updated successfully, but these errors were encountered: