Creating an Index with the ALTER TABLE Statement : Index : Table MySQL TUTORIALS

Creating an Index with the ALTER TABLE Statement

Related Scripts with Example Source Code in same category :
• Using Indexes
• Creating an Index
• CREATE INDEX index_name ON table_name (column_name[,...]);
• Using the ALTER TABLE statement to add an index
• Deleting Indexes
• ALTER TABLE table_name ADD (KEY|INDEX) index_name (column_name[,...]);
• ALTER TABLE Employee ADD (KEY) myIndex (id);
• Alter table to add an index on two columns
• SHOW INDEX FROM Employee;
• CREATE UNIQUE INDEX [index_name] ON table_name (column_name[,...]);
• ALTER TABLE Employee DROP INDEX lastn_idx;

Leave a Comment / Note

Name (required)

email (will not be published) (required)

Website

Vérification Refresh		Enter code
Verification is used to prevent unwanted posts (spam). .