SQLite supprimer données dupliquées
Bonjour,
J'ai la Tbale suivante: table_news contenant ces champs:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
| ROWID = INTEGER PRIMARY KEY AUTOINCREMENT
ID = TEXT NOT NULL
CONTENT = TEXT NOT NULL
ZONE TEXT = NOT NULL
AREA TEXT = NOT NULL
TITLE TEXT = NOT NULL
DATE TEXT = NOT NULL
AUTHOR TEXT = NOT NULL |
Elle est remplit comme ceci:
1st Row:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
| ROWID ==> 1
ID ==> "5"
CONTENT ==> "Discover New York."
ZONE ==> "New York"
AREA ==> "New York"
TITLE ==> "Let's discover the world."
DATE ==> "2012-07-04"
AUTHOR ==> "Henry Brakman"
2nd Row (same but with ROWID field setted to 2):
ROWID ==> 2
ID ==> "5"
CONTENT ==> "Discover New York."
ZONE ==> "New York"
AREA ==> "New York"
TITLE ==> "Let's discover the world."
DATE ==> "2012-07-04"
AUTHOR ==> "Henry Brakman" |
Je veux faire un sqlstatement qui va me supprimer les donnees redondantes (qui ont le meme ID par exemple).
J'ai essaye cela mais ca ne marche pas :
Code:
1
2
3
4
| public SQLiteStatement removeSameContentNews()
{
return bdd.compileStatement("DELETE FROM table_news WHERE ROWID NOT IN (SELECT MIN( ROWID) FROM table_news GROUP BY ID, CONTENT, ZONE, AREA, TITLE, DATE, AUTHOR)");
} |
Merci de m'aider les amis. :mrgreen:
