My problem is I am creating an archive table. I wish after selecting all records to be archived to copy them to a duplicate tabel that i have already created.
CREATE TABLE new_table SELECT * FROM old_table WHERE clause ;
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Growing old is mandatory - Growing up is optional Code Samples | Crowded Nightclub? | Bits & Bobs
