Dnia Thu, 27 Feb 2003 11:22:57 +0100
"Datatal AB - Gauffin, Jonas" <[EMAIL PROTECTED]> zeznał/a co następuje:
> Hello
>
> Have anyone got this error before:
> ERROR 1062: Duplicate entry '2147483647' for key 1
>
> I get it when I do a simple insert query. The primary key is an
> auto_increment f
There are couple of ways you can do it.
1) You can use the following sql to find out duplicate rows and then
write few more sql to delete duplicate.
SELECT column(s), count(*)
FROM
table-a
GROUP BY column(s)
HAVING count(*) > 1;
then massage the data with couple of more sqls.
2) This wa
Hi,
Try ALTER IGNORE TABLE your_table ADD UNIQUE
(column_where_you_dont_want_duplicates);
Regards,
Jocelyn Fournier
- Original Message -
From: "Oswaldo Castro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 26, 2002 8:20 PM
Subject: Duplicate Keys
> Hi List
>
> Sor