The table name: ims_hd_found_content
Fields: createtime (released)
Fields: createdate (publication date)
Field: the openid (released)


I want to delete the user specified release date is more than 15 days, all of the content of

CodePudding user response:

Select * from ims_hd_found_content where openid=the specified user id and datediff (now (), createtime) & gt; 15.

CodePudding user response:

Select * from ims_hd_found_content where openid=the specified user id and datediff (now (), createdate) & gt; 15.

CodePudding user response:

Delete from ims_hd_found_content where openid="' and now () - createdate> 15.

CodePudding user response:

references to learning turn _ reply: 3/f

delete from ims_hd_found_content where openid="' and now () - createdate> 15.

This is presupposed you get is not the number of days,