Assign a New Attribute to All Attribute Sets

assign-attribute-to-all-sets.sql

INSERT INTO `eav_entity_attribute` (
    `entity_type_id`,
    `attribute_set_id`,
    `attribute_group_id`,
    `attribute_id`,
    `sort_order`
) 
(
    SELECT 
        'ENTITY_TYPE_ID' AS entity_type_id,
        `attribute_set_id`,
        `attribute_group_id`,
        `attribute_id`,
        'SORT_ORDER' AS `sort_order`
    FROM `eav_attribute_group`, `eav_attribute`
    WHERE `attribute_group_name` = 'General'
        AND `attribute_code` = 'ATTRIBUTE_CODE'
)