Mysql || Export query CSV || get attributes - mpaz-redstage/magento-snippets GitHub Wiki

select value, eav_attribute_option.attribute_id from eav_attribute_option_value as eov join eav_attribute_option on eov.option_id = eav_attribute_option.option_id where attribute_id = 90 INTO OUTFILE '/var/lib/mysql/test.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';