mysql - Database: delete specific data -
i have columns in "user" table name , email , country, last_online ,as illustration :
> mohamed , email , uae , 2014-06-24 21:43:16 > > ali , email , ly , 2013-05-18 07:13:56 > > zeyad , email , eg , 2011-04-12 19:52:23
i want delete users info whom never logged since 2011-01-01 ,how can ?
a basic delete statement need:
delete user last_online <= '2011-01-01'
you should seek read on basic sql syntax.
mysql sql database
No comments:
Post a Comment