PROTECTED]
Sent: Monday, December 13, 2004 10:04 PM
To: [EMAIL PROTECTED]
Subject: Deleting redundant rows
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
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. Is there a solutio
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.
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 (0,'DDD'