List databases, tables, columns.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Fri, 11 Dec 2015 18:30:50 +0200
changeset 1811 072cc8a704ce
parent 1810 752c192306ff
child 1812 d676593e5541
List databases, tables, columns.
mysql.rst
--- a/mysql.rst	Fri Dec 11 18:11:50 2015 +0200
+++ b/mysql.rst	Fri Dec 11 18:30:50 2015 +0200
@@ -33,3 +33,29 @@
   $ mycli -u $USER
   Password:         <== Type password.
 
+List databases, tables, columns.
+================================
+::
+
+  $ mysql -u $USER -p
+  Enter password:   <== Type password.
+
+  SHOW DATABASES;
+
+  USE mysql;
+  MariaDB [mysql]> SHOW TABLES;
+
+  MariaDB [mysql]> SHOW COLUMNS FROM user;
+
+  MariaDB [mysql]> DESCRIBE user;
+
+  MariaDB [mysql]> SHOW STATUS;
+
+  MariaDB [mysql]> SHOW CREATE DATABASE mysql;
+  MariaDB [mysql]> SHOW CREATE TABLE user;
+
+  MariaDB [mysql]> SHOW GRANTS;
+
+  MariaDB [mysql]> SHOW WARNINGS;
+  MariaDB [mysql]> SHOW ERRORS;
+