On 21 Apr, 19:48, lawp...@gmail.com wrote:
> 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).

I'm no expert on terminology either

I can't see why you get the results you describe here...
> SELECT *
> FROM table
> WHERE client_id = 1
> AND guid = 'ba083c1576f8c555ef4ff0ae09dd33a7'
>
> and I get now results. Then, I do

> INSERT INTO table (
> client_id,
> guid
> ) VALUES (
> 1,
> 'ba083c1576f8c555ef4ff0ae09dd33a7'
> );

But if you could show us the datatypes and give us a bit more detail
about the keys, index and wotnot? I'm sure you'll be resourceful
enough to do that without giving away any confidential info

Pete