Skip to content

Latest commit

 

History

History
30 lines (24 loc) · 608 Bytes

findout-indexes.md

File metadata and controls

30 lines (24 loc) · 608 Bytes
Raw

Findout Indexes

Show index from table

create database showindex; 
use showindex;
CREATE TABLE `people` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(25) DEFAULT NULL,
  `last_name` varchar(25) DEFAULT NULL,
  `passcode` mediumint(8) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_passcode` (`passcode`),
  KEY `idx_first_name_last_name` (`first_name`,`last_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
show index from people

Show create table

show create table peple

show index from

show index from contributions