axel 中处理数据的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;