mysql修改删除添加查询连表操作(查询7天内的数据)

修改

update user as a left join activity as b on a.id=b.user_id set a.title=b.title,a.cont2=b.cont where b.odate < '2022-05-01';

删除

delete 表1(要删除的表) [,表2] from 表1 left join 表2…

delete a from user as a left join activity as b on a.id=b.user_id where b.odate < '2022-05-01';

添加

insert into user(title, title1, tittle2) select title, title1, tittle2 from activity where odate < '2022-05-01';

查询

select * from user where (select count(*) from activity where id in (1,2,3,4,5))=1 and ...

查询某字段小于7天内的数据

date_sub(curdate(), interval 7 day) <= date(字段)

select * from user where date_sub(curdate(), interval 7 day) <= date(odate) and operate!='d'