Skip to content

Instantly share code, notes, and snippets.

@parzibyte
Created March 1, 2021 20:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save parzibyte/a51b7ec70ea95b7ac27103d9687c5fd7 to your computer and use it in GitHub Desktop.
Save parzibyte/a51b7ec70ea95b7ac27103d9687c5fd7 to your computer and use it in GitHub Desktop.
MariaDB [visitas_php]> show indexes from visitas;
+---------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| visitas | 1 | indice_fecha | 1 | fecha | A | 10 | NULL | NULL | | BTREE | | |
+---------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
1 row in set (0.001 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment