t: Re: insert into x select * from x doesn't work
> I think this should be reported as a BUG for version 4.1
> Below is a small text retreived from the URL
> http://www.mysql.com/doc/en/INSERT_SELECT.html
>
> ---
> Prior to MySQL 4.0.14, the target table of the INSERT s
ect: Re: insert into x select * from x doesn't work
>
> Hi
>
> > In mysql 4.1 (and since mysql 4.0.14 or something like that) I
> > believe it's documented that an insert into X select * from X should
> > work.
>
> IIRC, the table you're INSERTi
limitation
is lifted in 4.0.14.
---
This should apply to 4.1.0 because it is not prior to 4.0.14 !
Thanks
Emery
- Original Message -
From: "Tedman Leung" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 29, 2003 08:08
Subject: insert
Tedman Leung <[EMAIL PROTECTED]> wrote:
> In mysql 4.1 (and since mysql 4.0.14 or something like that) I believe
> it's documented that an insert into X select * from X should work.
>
> It's not working for me on MySQL 4.1.0 alpha, anyone else have this
> problem? is it a bug? I haven't found
Hi
> In mysql 4.1 (and since mysql 4.0.14 or something like that) I
> believe it's documented that an insert into X select * from X should
> work.
IIRC, the table you're INSERTing into cannot be the same table you
SELECT from - you're trying to take records from the table 'foo' and
insert the
In mysql 4.1 (and since mysql 4.0.14 or something like that) I believe
it's documented that an insert into X select * from X should work.
It's not working for me on MySQL 4.1.0 alpha, anyone else have this
problem? is it a bug? I haven't found any other reports of this not
working for anyone