: Index : Table MySQL TUTORIALS
Ajax
Ajax Examples
Ajax Tutorials
Scripts and Programs
Javascript
Javascript Examples Tutorials
DHTML Tutorials
Javascript References
Scripts and Programs
HTML
HTML Tutorials
HTML References
HTML DOM 0 References
HTML DOM 2 References
CSS
CSS Tutorials
CSS References
PHP
PHP Source Code
PHP References
Scripts and Programs
C#
C# Source Code
C# Examples
MySQL TUTORIALS
»
Table
»
Index
»
53.1 .
ALTER TABLE Employee DROP INDEX lastn_idx;
Hits: 1215
53.2 .
CREATE UNIQUE INDEX [index_name] ON table_name (column_name[,...]);
Hits: 1292
53.3 .
SHOW INDEX FROM Employee;
Hits: 1114
53.4 .
Alter table to add an index on two columns
Hits: 1028
53.5 .
ALTER TABLE Employee ADD (KEY) myIndex (id);
Hits: 1153
53.6 .
ALTER TABLE table_name ADD (KEY|INDEX) index_name (column_name[,...]);
Hits: 1091
53.7 .
Deleting Indexes
Hits: 1542
53.8 .
Using the ALTER TABLE statement to add an index
Hits: 1158
53.9 .
CREATE INDEX index_name ON table_name (column_name[,...]);
Hits: 1142
53.10 .
Creating an Index with the ALTER TABLE Statement
Hits: 1088
53.11 .
Creating an Index
Hits: 1120
53.12 .
Using Indexes
Hits: 1118
MySQL TUTORIALS
Table
»
Index
Create Table
Column Modifiers
Describe Table Structure
Drop Column
Alter Table
Default
Copy Table
Key
Rename Table
PRIMARY KEY
TRUNCATE TABLE
Foreign Keys
Drop Table
Unique
Temporary Table
AUTO_INCREMENT
Add Column
Index
Alter Column
COLLATION Character Set
Aggregate Functions
Cast Functions Operators
Comparison Functions Operators
Control Flow Functions
Cursor
Data Dictionary
Data Types
Database
Date Time Functions
Encryption Compression Functions
Information Functions
Insert Update Delete
Introduction
Logic Operator
Math Numeric Functions
Miscellaneous Functions
MySQL Utilities
Privilege
Procedure Function
Regular Expressions
Select Query
String Functions
Subquery
Table
Table Join
Trigger
View
ALTER TABLE Employee DROP INDEX lastn_idx;
