use salarymarket; INSERT INTO company_activities_translate (description, activityId, languageId) SELECT ca.description, ca.id AS activityId, 2 AS languageId -- Français FROM company_activities ca WHERE ca.description IS NOT NULL;