MySQL insert
insert values
INSERT INTO
continent
VALUES
( 1, 2, 3)
continent
VALUES
( 1, 2, 3)
insert .. select all columns
INSERT INTO
continent
SELECT
country_region_id, cr_description
FROM
country_region
continent
SELECT
country_region_id, cr_description
FROM
country_region
insert ... select with named columns
INSERT INTO
translation_os
( ourservices_id, language_id, tos_osname )
SELECT
ourservices_id, 1, os_name
FROM
ourservices
translation_os
( ourservices_id, language_id, tos_osname )
SELECT
ourservices_id, 1, os_name
FROM
ourservices
Also see
MySqlSelect
REFERRERS
MySqlDataManipulation
MySqlSelect
