Database: delete specific data

Question

I have some columns in "user" table like name , email , country, last_online ,as example :

> 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 data whom never logged since 2011-01-01 ,How can i do it ?

Study up. http://dev.mysql.com/doc/refman/5.0/en/delete.html — Jaaz Cole, Jun 24 '14 at 19:58
http://stackoverflow.com/questions/10643379/how-do-i-query-for-all-dates-greater-than-a-certain-date-in-sql-server may be of help. Once you're happy with your select query, you can change it to a delete: http://dev.mysql.com/doc/refman/5.0/en/delete.html — KathyA., Jun 24 '14 at 19:59
@M Khalid Junaid this will delete which users ? below 2011 or above ? — Dr.Mezo, Jun 24 '14 at 20:06
First try `select * from user where last_login <= '2011-01-01'`. See the results that you're given. Understand why you get the results you do. Then, change the `select *` to `delete` and rerun the query. The rows that came up in the `select` will be the same rows that are `delete`d. — Andy Lester, Jun 24 '14 at 20:12
Thanks @Andy Lester , you can copy it as answer so i mark it right :) — Dr.Mezo, Jun 24 '14 at 20:36

score 0 · Accepted Answer · answered Jun 24 '14 at 20:42

0

A basic delete statement is all that you need:

delete from user where last_online <= '2011-01-01'

You should try to read up on basic SQL syntax.

answered Jun 24 '14 at 20:42

ktbird7

1 Answers1