INSERT with SELECT in mySQL

[boolean]

Hey pals...

Why wouldn't this query work in MySQL?:

INSERT INTO PAGE
(
PAGE_ID,
PAGE_NAME,
PAGE_LOCATION
)
SELECT 2,
PAGE_NAME,
PAGE_LOCATION
FROM PAGE WHERE PAGE_ID=1;

I just want to replicate the records for PAGE_ID=1... If this wouldn;t work, can anyone gimme a work around please....
FYI, i am using MySQL 4.0.12 Sham aka boolean... be practical/be straight... true/false?!

 

[swampBoogie]

This is a shortcoming in Mysql. You need to do it in two steps, first select the values into variables and then do an insert.

 

[boolean]

thanks boogie...

well... i have not really worked on Mysql as much as the other drivers... why dont you tell me how to go about it? and FYI the apps using inline queries... can the 2 steps done together in 1 query??
Sham aka boolean... be practical/be straight... true/false?!