MySQL Select
select
SELECT country_region_id, cr_description FROM country_region
select * into
SELECT country_region_id, cr_description INTO new_country_region FROM country_region
Also see
MySqlInsert
MySqlOrderBy
REFERRERS
MySqlDataManipulation
MySqlInsert