# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1453494348 -7200
# Node ID ff2e0241303cf1a6343e7e68bdebaf40d6643281
# Parent  b5f927fa28cec921ff6eeda22424b6530abb5e66
List indexes.

diff -r b5f927fa28ce -r ff2e0241303c mysql.rst
--- 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.
 ==================
 ::