Change Attribute for all simple products associated to a configurable

gistfile1.sql

UPDATE 
  catalog_product_entity_int 
SET 
  value = 1 -- new value
WHERE 
  attribute_id = 85 AND -- attribute_id you want to change
  entity_id IN (
                  SELECT DISTINCT product_id FROM catalog_product_super_link
                );