View Single Post

   
  #3 (permalink)  
Old 04-24-2008, 06:08 PM
lawpoop@gmail.com
 
Posts: n/a
Default Re: error with UNIQUE key length?

On Apr 21, 2:27 pm, "petethebl...@googlemail.com"
<petethebl...@googlemail.com> wrote:

> Can you export the table structure? Why are there 2 keys?


Well, the table structure is sort of confidential, I really can't
export it.

As far as two keys, I'm maybe using the terminology wrong. I have a
UNIQUE key on two columns. Each client should only have one instance
of the text in the table, so the key is UNIQUE(text_hash, client_id).
Reply With Quote