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...