用户名: 密码: 忘记密码? 注册

提供报表给derong

作者:  时间: 2010-10-12
/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