diff options
author | Hugues Hiegel <hugues@hiegel.fr> | 2008-12-11 14:00:53 +0100 |
---|---|---|
committer | Hugues Hiegel <hugues@hiegel.fr> | 2008-12-11 14:00:53 +0100 |
commit | e3f156e8625f661b09f950eaad3d4cfcc3b1e5d9 (patch) | |
tree | b3cfec9a3b8eebb669f10aef50debf8e47691961 | |
parent | eebd40439db54767852b8774702a8929a7d037cb (diff) |
[DB] mysql db cleanup script
-rw-r--r-- | database.cleanup | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/database.cleanup b/database.cleanup new file mode 100644 index 0000000..a3ebe2b --- /dev/null +++ b/database.cleanup @@ -0,0 +1,16 @@ + +USE lastfm + + +/** + * Deletes all entries in badges + * for each unique username + type + * where more than one style or color exists + */ + +DROP TABLE IF EXISTS tmp ; +CREATE TEMPORARY TABLE tmp (SELECT username, type, COUNT(username) AS count FROM badges GROUP BY username, type ) ; +DELETE badges FROM badges, tmp WHERE badges.username = tmp.username AND tmp.count > 1 ; +DROP TABLE tmp ; + + |