create a unique key on city,cc columns with ignore option of alter table it
will keep the first row and deletes redundant rows.
check the below link for alter table syntax
http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
Anil
-Original Message-
From: Walter Pucko [mailto:[EMAIL
Hello,
You can try delete/filter the redundant rows with this code:
(this is an option :D)
create table yourtable
(
id int not null auto_increment,
city varchar(20),
cc varchar(2),
primary key(id)
);
insert into yourtable values (0,'AAA','AA');
...
insert into yourtable values
Walter Pucko wrote:
Hello there,
I do have a table in mysql 4.x with redundant info. Only the autoincrement
ID is different.
Example:
ID citycc
2559756 Witkop SF
2559757 Witkop SF
This turns to be a huge problem since I cant find a way to delete the
redundant rows with a mysql query.