MySQL -- Crear tabla temporal con consulta y popular tabla con consulta

mysql-populate-from-select.sql

--
-- Add Brentwood Employees
--
INSERT INTO employee_brentwood (
  user_name,
  user_firstname,
  user_surname,
  user_email,
  user_password,
  user_level,
  user_avatar_file,
  user_timezone,
  user_address1,
  user_address2,
  user_city,
  user_zip,
  user_position,
  user_department,
  user_phone,
  user_phone_ext,
  user_mobile,
  user_fax,
  user_country,
  user_region,
  user_locale,
  user_last_login,
  user_is_deleted,
  user_permanently_deleted,
  fldEmployeeID
)
SELECT
  CONCAT(LOWER(TRIM(fldFirstName)), '_', LOWER(TRIM(fldLastName))),
  TRIM(fldFirstName),
  TRIM(fldLastName),
  TRIM(LOWER(fldEmailAddress)),
  SHA1(Brentwood_tblEmployees.fldEmployeeID),
  'staff_tutor',
  NULL,
  'America/Chicago',
  TRIM(fldAddressLine1),
  TRIM(fldAddressLine2),
  TRIM(fldCity),
  TRIM(fldZip),
  TRIM(fldTitle),
  'Staff',
  TRIM(fldHomePhone),
  '',
  TRIM(fldMobilePhone),
  TRIM(fldFax),
  'USA',
  'en_US',
  'en_US',
  NULL,
  'no',
  'no',
  fldEmployeeID
FROM Brentwood_tblEmployees
WHERE fldEmployeeID NOT IN (SELECT fldEmployeeID FROM employee_brentwood)
AND TRIM(fldEmailAddress) <> ''
AND LOCATE('@', fldEmailAddress) > 0;

mysql-temp-table.sql

-- Create Index on fldCompanyName
DROP TABLE IF EXISTS temp_brentwood_company_name;

-- Create temporary table
CREATE TEMPORARY TABLE temp_brentwood_company_name
SELECT DISTINCT TRIM(fldCompanyName) AS fldCompanyName
FROM Brentwood_tblContacts
WHERE fldContactId NOT IN (SELECT fldContactId FROM company WHERE tt_location = 'brentwood')
AND fldContactTypeID = 6
AND TRIM(fldEmailAddress) <> ''
AND LOCATE('@', fldEmailAddress) > 0;