Also ensure you issue: FLUSH PRIVILEGES; after making any changes to
permissions..
On 24 September 2012 20:09, Rick James wrote:
> That says that your password in not correct. You have not gotten to specific
> privileges.
>
> Did you previously do
> GRANT ... TO myuser@localhost IDENTFIED BY '.
SELECT id FROM mytable WHERE type IN(x,y,z) GROUP BY id;
On 22 November 2012 15:01, Neil Tompkins wrote:
> Michael,
>
> Thanks this kind of works if I'm checking two types. But what about if I
> have 5 types ?
>
> On Thu, Nov 22, 2012 at 2:53 PM, Michael Dykman wrote:
>
>> response did not go t
BY id HAVING listid = 'x,y,z';
On 22 November 2012 15:10, Ben Mildren wrote:
> SELECT id FROM mytable WHERE type IN(x,y,z) GROUP BY id;
>
> On 22 November 2012 15:01, Neil Tompkins wrote:
>> Michael,
>>
>> Thanks this kind of works if I'm checking
*HAVING typelist = 'x,y,z';
On 22 November 2012 15:25, Ben Mildren wrote:
> Ah read it quickly and misread your requirement. Joins are likely FTW
> here. The alternative would be to do something like this, but I'd opt
> for the joins if you have a reasonably sized
