/* Primary INDEXING */ ALTER TABLE `TABLE_NAME` ADD PRIMARY KEY (`ID`); /* General INDEXING (1 or more field) */ ALTER TABLE `TABLE_NAME` ADD INDEX `INDEX_NAME` (`FIELD_1`, `FIELD_2`); /* Unique INDEXING (1 or more field) */ ALTER TABLE `TABLE_NAME` ADD UNIQUE `INDEX_NAME` (`FIELD_1`, `FIELD_2`); /* Fulltext INDEXING (1 or more field) */ ALTER TABLE `TABLE_NAME` ADD FULLTEXT `INDEX_NAME` (`FIELD_1`, `FIELD_2`); /* Remove INDEXING */ DROP INDEX `INDEX_NAME` ON `TABLE_NAME`; /* List INDEXING */ SHOW INDEX FROM `TABLE_NAME`;
Showing posts with label unique-indexing. Show all posts
Showing posts with label unique-indexing. Show all posts
Saturday, December 2, 2017
MySQL Table Create Index Remove Index List Index | Primary Indexing | Unique Indexing | Field Indexing | FullText Indexing
Subscribe to:
Posts (Atom)