实用sql(2) 复制某个日期的数据

INSERT INTO ads_point_premises_snt (sum_type, sum_id, sum_name, point_num_in,point_num_out,property_type,is_core,is_xinchao,cooperation_model,uu_id,etl_time,data_date )
select sum_type,sum_id,sum_name,point_num_in,point_num_out,property_type,is_core,is_xinchao,cooperation_model,uu_id,etl_time,'2021-07-30' from ads_point_premises_snt where data_date='2021-05-31';