Hi!
So I am of the school of thought that most SHOW commands should go to
the command line client and be purged from parser. Ronald wrote the
following article:
http://ronaldbradford.com/blog/a-beginners-look-at-drizzle-getting-around-with-show-2009-03-31/
Here is a list of current show commands:
SHOW COLUMNS FROM information_schema.tables;
SHOW CREATE DATABASE information_schema;
SHOW DATABASES;
SHOW ENGINE INNODB STATUS;
SHOW ERRORS;
SHOW INDEX FROM information_schema.tables;
SHOW OPEN TABLES;
SHOW PROCESSLIST;
SHOW STATUS;
SHOW TABLE STATUS;
SHOW TABLES;
SHOW VARIABLES;
SHOW WARNINGS;
SHOW CREATE SCHEMA;
SHOW SCHEMAS;
Anyone have thoughts on what should stay or go? The keyword "FULL"
exists for several of these. For COLUMNS I suspect it could just be on
by default. SHOW INDEX looks odd.
Other thoughts? TABLE TABLE STATUS? OPEN TABLES?
Cheers,
-Brian
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
