Support for SHOW and EXPLAIN

[GoogleCodeExporter]

Would make parser more complete...

Original issue reported on code.google.com by adrian.p...@googlemail.com on 18 Oct 2012 at 2:49

[GoogleCodeExporter]

in php-sql-creator that is.

Original comment by adrian.p...@googlemail.com on 18 Oct 2012 at 3:04

[GoogleCodeExporter]

Original comment by greenlion@gmail.com on 13 Dec 2012 at 8:35

• Changed state: Accepted
• Added labels: Priority-Low, Type-Enhancement
• Removed labels: Priority-Medium, Type-Defect

[GoogleCodeExporter]

I have added support for EXPLAIN SELECT, EXPLAIN <table> and DESCRIBE <table>. 
See r406.

Original comment by pho...@gmx.de on 2 Nov 2013 at 6:22

• Changed state: Started

[GoogleCodeExporter]

I have added parser support for the following SHOW statements:

SHOW CHARACTER SET [LIKE 'pattern']
SHOW COLLATION [LIKE 'pattern']
SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE 'pattern']
SHOW CREATE DATABASE db_name
SHOW CREATE FUNCTION funcname
SHOW CREATE PROCEDURE procname
SHOW CREATE TABLE tbl_name
SHOW DATABASES [LIKE 'pattern']
SHOW ENGINE engine_name {LOGS | STATUS }
SHOW [STORAGE] ENGINES
SHOW ERRORS [LIMIT [offset,] row_count]
SHOW FUNCTION STATUS [LIKE 'pattern']
SHOW GRANTS FOR user
SHOW INDEX FROM tbl_name [FROM db_name]
SHOW INNODB STATUS
SHOW PROCEDURE STATUS [LIKE 'pattern']
SHOW [BDB] LOGS
SHOW PLUGIN
SHOW PRIVILEGES
SHOW [FULL] PROCESSLIST
SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern']
SHOW TABLE STATUS [FROM db_name] [LIKE 'pattern']
SHOW [OPEN] TABLES [FROM db_name] [LIKE 'pattern']
SHOW TRIGGERS
SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern']
SHOW WARNINGS [LIMIT [offset,] row_count]

The creator dosn't support SHOW at the moment. See r408.

Original comment by pho...@gmx.de on 3 Nov 2013 at 2:49

[GoogleCodeExporter]

I have added the SHOW statement to the Creator, see r414.

Original comment by pho...@gmx.de on 4 Nov 2013 at 9:04

• Changed state: Fixed