Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
docs:mysql:show [2007/03/21 10:05] billhdocs:mysql:show [2008/08/03 00:25] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +====== 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;
  
 +===== See Also =====
 +  * [[character_sets|Character Sets]]
 +  * [[grant|GRANT]]
 +
 +===== External Links =====
 +  * http://dev.mysql.com/doc/refman/4.1/en/show.html
 +  * http://dev.mysql.com/doc/refman/4.1/en/show-grants.html