mysql语句

update point set point.boundry=b_point.p_index from point,b_point where point.point_x_y=b_point.point_x_y;
select count(*) from point,b_point where point.point_x_y=b_point.point_x_y;
update point inner join b_point on point.point_x_y=b_point.point_x_y set point.boundry=b_point.p_index;
select * from b_point left join point on point.point_x_y=b_point.point_x_y;

truncate table point;
truncate table b_point;
truncate table quad;

原文：http://www.cnblogs.com/zhuyaguang/p/4719183.html