数据表清空数据

– 1.新建临时表
create table tc_transhippoint_info_v1_temp like tc_transhippoint_info_v1 ;

– 2.重命名旧表做备份
alter table tc_transhippoint_info_v1 rename to tc_transhippoint_info_v1_delete_20211021;

– 3.修改临时表名为表tc_transhippoint_info_v1
alter table tc_transhippoint_info_v1_temp rename to tc_transhippoint_info_v1;

以下为异常数据回滚脚本！！！======================

– 1.新表重命名
alter table tc_transhippoint_info_v1 rename to tc_transhippoint_info_v1_temp1021;

– 2.回滚旧表
alter table tc_transhippoint_info_v1_delete_20211021 rename to tc_transhippoint_info_v1;

– 删除无用表
drop table tc_transhippoint_info_v1_temp1021;

=================部分数据删除备份=
– 删除备份
create table tc_transhippoint_info_v1_20211124_deleted like tc_transhippoint_info_v1;

INSERT INTO tc_transhippoint_info_v1_20211124_deleted select * from tc_transhippoint_info_v1 where joint_code in ();

– 删除无效接驳点数据
delete from tc_transhippoint_info_v1 where joint_code in ();