Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MUL key in table : need to remove this!

Status
Not open for further replies.
Blood22

Blood22

Technical User
Jul 14, 2003
7
0
0
GB
I have looked everywhere for answers! I am fairly new to MySQL and am trying to remove the MUL key from the starttime and endtime fields in my database.

The fields are datetime types.

If anyone can help me here I would do backflips!

Si22.
 
Sort by date Sort by votes
Its ok, found answer...

ALTER TABLE table_name DROP INDEX index_name

Cheers anyhoo,

Si22.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
Looking for suggestions on how to do this
Replies
4
Views
124
Chris Miller
Chris Miller
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
103
EdLentz
EdLentz
boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
155
spamjim
spamjim
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
136
lupidol
lupidol
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
139
EdLentz
EdLentz

Part and Inventory Search

Sponsor

Back
Top