>Description:
copying a table with a fulltext index via
insert into ft1 select * from ft2;
into a identical table sometimes leads to select error 1191
when concurrent select's are running.
this happens in an enviroment where the searched
= fake.id; it
> simply doesn't know where to get fake.id
>
>
> >From: Ed Curtis <[EMAIL PROTECTED]>
> >To: mysql@lists.mysql.com
> >Subject: SELECT ERROR
> >Date: Wed, 23 Feb 2005 08:02:21 -0500 (EST)
> >
> >
> >I'm trying to com
s.mysql.com
Subject: SELECT ERROR
Date: Wed, 23 Feb 2005 08:02:21 -0500 (EST)
I'm trying to compare 2 tables and keep getting an error.
SELECT * from listings where listings.id = fake.id;
The error is "Error 1109: Unknown table 'fake' in where clause"
or "Error 1109:
I'm trying to compare 2 tables and keep getting an error.
SELECT * from listings where listings.id = fake.id;
The error is "Error 1109: Unknown table 'fake' in where clause"
or "Error 1109: Unknown table 'listings' in where clause" depending on
the table order at the end of the query.
Both tabl
Hi David,
Can you run the query in the MySQL command line client?
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Zak Greant <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate
/_/ /_/\_, /___/\___\_\___/ Calgary, Canada
<___/ www.mysql.com
