MySQL删除数据 1、删除一周之前的数据 注意函数yearweek delete from t_student where yearweek(data_format(cre_time,'%Y-%m-%d')) < yearweek(now()) 2、删除id in(’’,’’…) 注意collection的类型 delete from t_student where id in <foreach collection="array" item="oneId" open="(" close=")" separator=","> #{oneId} </foreach>