Dupliacetes.

[Andreas Karydis]

Hi,

I created the following table (btw I haven't added a key it's a long time since I used databases, if there is something wrong w/ everything you see in the following I will paste please feel free to correct me.)

mysql> describe bluray;
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| Title | varchar(250) | YES | | NULL | |
| Genre | varchar(50) | YES | | NULL | |
| Region | char(1) | YES | | NULL | |
| Duration | time | YES | | NULL | |
+----------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

I have there values


mysql> select * from bluray;
+-------------------------------------------------------+-----------+--------+----------+
| Title | Genre | Region | Duration |
+-------------------------------------------------------+-----------+--------+----------+
| Pirates Of The Caribbean-Dead Mans Chest | ACTION | B | NULL |
| Pirates Of The Caribbean-The Curse Of The Black Pearl | ACTION | B | NULL |
| Pirates Of The Caribbean-On Stranger Tides | ACTION | B | NULL |
| Pirates Of The Caribbean-At Worlds End | ACTION | B | NULL |
| Pirates Of The Caribbean-Salazars Revenge | ACTION | B | NULL |
| The Lord Of The Rings-The Fellowship Of The Ring | ACTION | B | NULL |
| The Lord Of The Rings-The Rerurn Of The King | ACTION | B | NULL |
| The Lord Of The Rings-The Two Towers | ACTION | B | NULL |
| Lethal Weapon | ACTION | B | NULL |
| Lethal Weapon 2 | ACTION | B | NULL |
| Lethal Weapon 3 | ACTION | B | NULL |
| Lethal Weapon 4 | ACTION | B | NULL |
| Shark Night | Horror | B | NULL |
| S.W.A.T | Action | B | NULL |
| Escapee | Action | B | NULL |
| Flatliners | Action | B | NULL |
| Star Wars-The Force Awakens | SCIFI | B | NULL |
| Untraceable | Action | B | NULL |
| I-Robot | SCIFI | B | NULL |
| RAMBO | Action | B | NULL |
| Curse Of Chucky | Horror | B | NULL |
| Alice In Wonderland 3D | Adventure | B | NULL |
| Face Off | Action | B | NULL |
| The Haunting In Connecticut | Horror | B | NULL |
| The Host | SCIFI | B | NULL |
| Gone In 60 Seconds | Action | B | NULL |
| The Expendables | Action | B | NULL |
| The Expendables 3 | Action | B | NULL |
| The Martian | SCIFI | B | NULL |
| 28 Days Later | Horror | B | NULL |
| 28 Weeks Later | Horror | B | NULL |
| Die Hard 4.0 | Action | B | NULL |
| Minority Report | SCIFI | B | NULL |
| Pirates Of The Caribbean-Dead Mans Chest | ACTION | B | NULL |
| Pirates Of The Caribbean-The Curse Of The Black Pearl | ACTION | B | NULL |
| Pirates Of The Caribbean-On Stranger Tides | ACTION | B | NULL |
| Pirates Of The Caribbean-At Worlds End | ACTION | B | NULL |
| Pirates Of The Caribbean-Salazars Revenge | ACTION | B | NULL |
| The Lord Of The Rings-The Fellowship Of The Ring | ACTION | B | NULL |
| The Lord Of The Rings-The Rerurn Of The King | ACTION | B | NULL |
| The Lord Of The Rings-The Two Towers | ACTION | B | NULL |
| Lethal Weapon | ACTION | B | NULL |
| Lethal Weapon 2 | ACTION | B | NULL |
| Lethal Weapon 3 | ACTION | B | NULL |
| Lethal Weapon 4 | ACTION | B | NULL |
| Shark Night | Horror | B | NULL |
| S.W.A.T | Action | B | NULL |
| Escapee | Action | B | NULL |
| Flatliners | Action | B | NULL |
| Star Wars-The Force Awakens | SCIFI | B | NULL |
| Untraceable | Action | B | NULL |
| I-Robot | SCIFI | B | NULL |
| RAMBO | Action | B | NULL |
| Curse Of Chucky | Horror | B | NULL |
| Alice In Wonderland 3D | Adventure | B | NULL |
| Face Off | Action | B | NULL |
| The Haunting In Connecticut | Horror | B | NULL |
| The Host | SCIFI | B | NULL |
| Gone In 60 Seconds | Action | B | NULL |
| The Expendables | Action | B | NULL |
| The Expendables 3 | Action | B | NULL |
| The Martian | SCIFI | B | NULL |
| 28 Days Later | Horror | B | NULL |
| 28 Weeks Later | Horror | B | NULL |
| Die Hard 4.0 | Action | B | NULL |
| Minority Report | SCIFI | B | NULL |
| Ouija | Horror | B | NULL |
| Thir13en Ghosts | Horror | B | NULL |
| Mothers Day | Horror | B | NULL |
| The Expatriate | Action | B | NULL |
| Bram Stokers-Dracula | Horror | B | NULL |
| Doom-No One Gets Out Alive | Action | B | NULL |
| Blue Streak | Comedy | B | NULL |
| Hannibal | Horror | B | NULL |
| The Burma Conspiracy | Action | B | NULL |
| Recoil | Action | B | NULL |
| Psycho | Horror | B | NULL |
| The Roommate | Horror | B | NULL |
| Red Dragon | Horror | B | NULL |
| The Bourne Classified Collection | Action | B | NULL |
| Alice In Wonderland | Adventure | B | NULL |
| Alice Through The Looking Glass | Adventure | B | NULL |
| National Security | Comedy | B | NULL |
| Rec 2 | Horror | B | NULL |
| Secret Window | Horror | B | NULL |
| The Resident Evil Collection | Horror | B | NULL |
+-------------------------------------------------------+-----------+--------+----------+
86 rows in set (0.00 sec)

how can I get rid of the duplicates?i don't remember adding two times the values.Thanks.