mysql> USE dw;
DATABASE changed
mysql> TRUNCATE `sale_estate_avgprice`;
Query OK, 0 rows affected (0.03 sec)
mysql> source /DATA/bak/sql/1.2.8/1.2.8-sale_estate_avgprice_zcg.sql;
mysql> USE yoohouse_alpha
DATABASE changed
mysql> UPDATE house_estate SET house_estate.estate_avgPrice=0;
Query OK, 6400 rows affected (0.28 sec)
Rows matched: 17245 Changed: 6400 Warnings: 0
mysql> UPDATE house_estate , dw.sale_estate_avgprice SET house_estate.estate_avgPrice=dw.sale_estate_avgprice.avg_price WHERE house_estate.estate_id=dw.sale_estate_avgprice.estate_id AND dw.sale_estate_avgprice.timestamp=1281225600;
Query OK, 5806 rows affected (0.31 sec)
Rows matched: 5806 Changed: 5806 Warnings: 0
阅读(518) | 评论(0) | 转发(0) |
