s error in case of duplicate 'abcd' (>= 3 chars).
Why?
Best regards, Denis Gerasimov
Outsourcing Services Manager,
VEKOS, Ltd.
www.vekos.ru
> -Original Message-
> From: Chris [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 23, 2004 9:56 PM
> To: MySQL Ge
To me, that error means that you ALREADY HAVE duplicates in your data. You
will have to eliminate the dupes before you can create the unique index.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Chris <[EMAIL PROTECTED]> wrote on 12/23/2004 01:55:34 PM:
> When specifying an
When specifying an index for TEXT and BLOB types, you must specify a length.
as an example...
CREATE TABLE test
(
sValue TINYTEXT NOT NULL,
UNIQUE KEY(sValue(90))
)
Denis Gerasimov wrote:
Hello,
Is that possible to ensure uniqueness for a TINYTEXT field?
I tried to create an index (with UNIQUE c