Friday, 15 August 2014

mysql - Database: delete specific data -



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