Tutorials for MySQL

Creating A MySQL Composite Index

An index can be created in one or more columns. IF the number of columns included in an index is greater than one it’s known as a: Composite index

Composite index:

An index created on multiple table data columns is called a composite index as shown in Diagram 1.
The following is the syntax for creating composite index.

<System prompt> CREATE INDEX <IndexName> ON <Table Name> (<Column Name1>, <Column Name2>);

mysql> CREATE INDEX product_id ON productdetail (Serial_NO, ID);

Diagram 1

Subscribe Now


Buy Our Joomla Ebook

Joomla Ebook

Setup Your Joomla 2.5.X Website From Scratch

By Ivan Bayross Cost USD 9.99/- only

Buy Now

160 pages packed with immediately usable information
Freebies worth 250 USD/- come with this purchase

Our Latest Tweets