mysql> USE yoohouse_alpha
DATABASE changed
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, 5805 rows affected (0.46 sec)
Rows matched: 5805 Changed: 5805 Warnings: 0
阅读(561) | 评论(0) | 转发(0) |
