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 city cc
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 solution for that? I tried it
with distinct, but that does not work, with subselects but this seems not to
be supported.
ALTER IGNORE TABLE yourtable ADD UNIQUE (city,cc);
<URL: http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]