Hi, 4.1.0 was released before 4.0.14 so it wouldn't have the new functionality in it. It should be in 4.1.1 but hasn't been added to the change-log yet.
Matt ----- Original Message ----- From: "Director General: NEFACOMP" Sent: Monday, September 29, 2003 4:51 AM Subject: 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 limitation > is lifted in 4.0.14. > ----------- > > This should apply to 4.1.0 because it is not prior to 4.0.14 !!!!! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]