提供报表给derong
时间:2010-10-12 来源:sxxs001
/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
相关阅读 更多 +