分类： Mysql/postgreSQL
2010-10-12 16:41:51
/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
