List indexes.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Fri, 22 Jan 2016 22:25:48 +0200
changeset 1880 ff2e0241303c
parent 1879 b5f927fa28ce
child 1881 889e37c1c5b5
List indexes.
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.
 ==================
 ::