Show Index From Table
MariaDB [classicmodels]> SHOW INDEX FROM customers;
+-----------+------------+------------------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-----------+------------+------------------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| customers | 0 | PRIMARY | 1 | customerNumber | A | 122 | NULL | NULL | | BTREE | | |
| customers | 1 | salesRepEmployeeNumber | 1 | salesRepEmployeeNumber | A | 40 | NULL | NULL | YES | BTREE | | |
| customers | 1 | customerName | 1 | customerName | NULL | NULL | NULL | NULL | | FULLTEXT | | |
+-----------+------------+------------------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
PreviousHow to use DESCRIBE and EXPLAIN in MySQL?NextHỏi làm thế nào để sao lưu, khôi phục lại hệ thống Xampp?
Last updated