This is an old revision of the document!
SHOW
Examples
- help SHOW;
- SHOW DATABASES;
- SHOW GRANTS [FOR user];
- SHOW GRANTS;
- SHOW GRANTS FOR 'root'@'localhost';
- SHOW GRANTS FOR CURRENT_USER;
- SHOW GRANTS FOR CURRENT_USER();
- (after executing “USE databasename”)
- SHOW TABLES;
- SHOW COLUMNS FROM tablename;