
'LC1'),
 ('Fanny', 'Crowne', 'Restocker', '1023 Bokanovsky Lane', '326-555-6329',
'FC1'),
 ('Helmholtz', 'Watson', 'Janitor', '944 Soma Court', '329-555-2478', 'HW1');

SHOW INDEXES FROM employees_example\G
*************************** 1. row ***************************
    Table: employees_example
 Non_unique: 0
  Key_name: PRIMARY
 Seq_in_index: 1
 Column_name: id
  Collation: A
 Cardinality: 6
  Sub_part: NULL
   Packed: NULL
    Null:
 Index_type: BTREE
   Comment:
Index_comment: 
   Ignored: NO
*************************** 2. row ***************************
    Table: employees_example
 Non_unique: 0
  Key_name: employee_code
 Seq_in_index: 1
 Column_name: employee_code
  Collation: A
 Cardinality: 6
  Sub_part: NULL
   Packed: NULL
    Null:
 Index_type: BTREE
   Comment:
Index_comment: 
   Ignored: NO
*************************** 3. row ***************************
    Table: employees_example
 Non_unique: 1
  Key_name: first_name
 Seq_in_index: 1
 Column_name: first_name
  Collation: A
 Cardinality: NULL
  Sub_part: NULL
   Packed: NULL
    Null:
 Index_type: BTREE
   Comment:
Index_comment: 
   Ignored: NO
*************************** 4. row ***************************
    Table: employees_example
 Non_unique: 1
  Key_name: first_name
 Seq_in_index: 2
 Column_name: last_name
  Collation: A
 Cardinality: NULL
  Sub_part: NULL
   Packed: NULL
    Null:
 Index_type: BTREE
   Comment:
Index_comment: 
   Ignored: NO

URL: https://mariadb.com/kb/en/show-index/