List indexes.
--- a/mysql.rst Fri Jan 22 22:14:58 2016 +0200
+++ b/mysql.rst Fri Jan 22 22:25:48 2016 +0200
@@ -37,8 +37,8 @@
$ mycli -u $USER
Password: <== Type password.
-List databases, tables, columns.
-================================
+List databases, tables, columns, indexes.
+=========================================
::
$ mysql -u $USER -p
@@ -60,6 +60,16 @@
MariaDB [mysql]> SHOW GRANTS;
+List indexes::
+
+ SELECT * FROM INFORMATION_SCHEMA.STATISTICS;
+
+ SHOW INDEX FROM tbl;
+
+ SHOW INDEX FROM tbl FROM db;
+
+ SHOW CREATE TABLE tbl;
+
Table/index sizes.
==================
::