I have a fairly simple test database:

```
id  email
1   blue@yellow.com
2   pink@test.com
3   ace@ace.com
4   ace@ace.com
5   peter@something.com
6   peter@something.com
7   mouse@mouse.com
8   monkeyman@test.com
9   mouse@mouse.com

```

I want to remove duplicates which should alter the table to:

```
id  email
1   blue@yellow.com
2   pink@test.com
3   ace@ace.com
5   peter@something.com
7   mouse@mouse.com
8   monkeyman@test.com

```

Or with a new id it does not matter.

I stumbled upon this titbit:

```
mysqli_query($con,"ALTER IGNORE TABLE mytest ADD UNIQUE (email,id)");

```

But, alas, it does nothing. What am I doing wrong?