On 23 Apr, 15:06, lawp...@gmail.com wrote:
> On Apr 23, 10:26 am, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
> > On 23 Apr, 14:22, lawp...@gmail.com wrote:> On Apr 23, 9:14 am, "Peter H. Coffin" <hell...@ninehells.com> wrote:
>
> > And of course, it is totally beyond you to export the structure and
> > just rename the fields.
>
> > But I guess that takes a modicum of intelligence.
>
> It's not *totally* beyond me, but it would be an extra, unnecessary
> step. I got the answers I was asking for:
>
> Steve Lefevre
> "Am I getting the error because my UNIQUE key is too long? This is
> MySQL 5.0.24a.
>
> Is there a way to actually look at the values for the keys in my
> table? "
>
> Rik Wasmus:
> "mysql> insert into unique_test value
> ('12345678912345678912345678912345',2);
> Query OK, 1 row affected (0.01 sec)"
>
> No problems here whatsoever. Your UNIQUE is not properly created.
> The
> fastest way to show the key is by issuing a SHOW CREATE TABLE
> <tablename>;
> query. "
>
> Doing more work isn't going to change the answers.

But you didn't bother to tell anybody that you had solved it.