* marc malacarme
> I can¹t seem to make any of the describe or show queries work
> when I apply a search statement:
> Query=show table status from demo;
> Works fine. Now I¹m trying to get info from only one table:
> Query=show table status from demo where name like "user_access";
> Does no work.
Hrm. Closest I can think of is
EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access';
I think this is what you mean.
Adam Hooper
[EMAIL PROTECTED]
On Fri, 31 May 2002 08:44:49 -0700
marc malacarme <[EMAIL PROTECTED]> wrote:
> I can¹t seem to make any of the describe or show queries work wh
marc,
Friday, May 31, 2002, 6:39:54 PM, you wrote:
mm> I can¹t seem to make any of the describe or show queries work when I apply a
mm> search statement:
mm> Query=show table status from demo;
mm> Works fine. Now I¹m trying to get info from only one table:
mm> Query=show table status from demo w
Hrm. Closest I can think of is
EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access';
I think this is what you mean.
Adam Hooper
[EMAIL PROTECTED]
On Fri, 31 May 2002 08:44:49 -0700
marc malacarme <[EMAIL PROTECTED]> wrote:
> I can¹t seem to make any of the describe or show queries work wh
I can¹t seem to make any of the describe or show queries work when I apply a
search statement:
Query=show table status from demo;
Works fine. Now I¹m trying to get info from only one table:
Query=show table status from demo where name like "user_access";
Does no work.
Thank You
I can¹t seem to make any of the describe or show queries work when I apply a
search statement:
Query=show table status from demo;
Works fine. Now I¹m trying to get info from only one table:
Query=show table status from demo where name like "user_access";
Does no work.
Thank You
