MySQL Forums
Forum List  »  Optimizer & Parser

Re: Can't get my indexes right
Posted by: KimSeong Loh
Date: November 27, 2005 07:28PM

Seems like the problem is the tinytext name field, and the UNIQUE (name(128))

Maybe it is better to use a VARCHAR(255) instead of TINYTEXT and UNIQUE(name) instead of using the prefix of 128. If you want only 128 chars, specify 128 in the varchar definition instead.

Options: ReplyQuote


Subject
Views
Written By
Posted
3461
November 26, 2005 04:53PM
Re: Can't get my indexes right
2289
November 27, 2005 07:28PM
2137
November 28, 2005 02:44AM
2345
November 28, 2005 03:17AM
2080
November 28, 2005 07:40AM
2209
November 28, 2005 02:19PM
2198
December 21, 2005 10:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.