Removing duplicate rows with MYSQL

Databases
21

As you said viola!

I re-read all the threads and all I could think of was that I was playing a really bad game of battleship. I was calling shots everywhere except where they counted.

r937, thanks for sticking with me.

FYI, I got a Deja Vu towards the end of this topic so I sure this was an intended experience for me .

Thanks Again,

Niche

22

P.S.

ALTER IGNORE TABLE stk2 ADD UNIQUE (pic)

created

UNIQUE KEY pic (pic)

is there a script similar to ALTER IGNORE TABLE stk2 ADD UNIQUE (pic) that
removes dupes using an existing UNIQUE KEY?

I tried ALTER IGNORE TABLE stk2 UNIQUE (pic) unsuccessfully thinking it might have been able to use the exisiting UNIQUE KEY ‘pic’

or must the target column not be an existing unique key for ALTER IGNORE TABLE to work?

23

and now there are no more dupes, right?

24

You’re absolutely right! Thank-you very much.

r937, thanks for sticking with me.

FYI, I got a Deja Vu towards the end of this topic so I sure this was an intended experience for me .

Thanks Again,

Niche