CODEWITHSUNDEEP
mysqldatabase
TIMEX
TIMEX

Reputation: 271904

How do I add an index to a column that is datetime?

Possible Duplicate
How does one create an index on the date part of DATETIME field in MySql

In mysql. It's a date column

Upvotes: 3

Views: 252

Answers (1)

Mark Byers
Mark Byers

Reputation: 838376

You do it in the same way as you would for any other column type:

CREATE INDEX IX_tblname_columnname
ON tbl_name (columnname)

See the documentation for more information and other options.

Upvotes: 2

Related Questions