常用SQL

（1）找出表中重复数据（大于1的）
SELECT COUNT(house_bill_no) a FROM hb_contractpre_sale GROUP BY house_bill_no HAVING a > 1;

（2）关联更新
update tbl_rooms room,system_sys_attachment sys set sys.src_bill_no = room.id ,sys.src_type=‘tblRooms’
where room.roomsn = sys.src_bill_no and sys.src_type=‘house’ and sys.src_bill_no like ‘GY%’ ;