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 INSERTing into cannot be the same table you SELECT from - you're trying to take records from the table 'foo' and insert them

Re: insert into x select * from x doesn't work

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 any

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 statement cannot appear in the FROM clause of the SELECT part of the query. This

Re: insert into x select * from x doesn't work

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 INSERTing into cannot be the same table you SELECT from - you're trying to take records from

Re: insert into x select * from x doesn't work

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 statement cannot appear in the FROM clause