/usr/local/mysql/bin/mysql -uroot -p"qazdb2009p;/$" yoohouse_alpha -B -e "select estate_id,estate_district,estate_sector,estate_name,estate_address from house_estate where estate_plan_pic is null \ and estate_looks_pic is null and \ estate_scene_pic is null and estate_indoor_pic is null and estate_roomtype_pic is null and estate_visable = 1 group by estate_name order by estate_district asc,estate_sector asc;" \ | sed 's/\t/,/g' > estate.csv
提供报表给derong
作者: sxxs001 发布时间: 2010-10-12