是否有任何纯sql方法可以以以下方式从日志表中删除数据

I have a two tables 1. main_table 2. log_table On main_table a trigger is defined that copies the affected rows to log_table on delete and update. In log_table the columns are same except two extra column pid(primary key int) and updateat(time stamp).I have a two tables 1. main_table 2. log_table