Hello Gerald,
what would you suggest?? Should I give you a list of all 600.000 entries in
the table?? And there is nothing special about the structure ... they are
similar .. with only one single-column primary key.
And the key being different each time I run the script should tell you that
there is something wrong.
And I even tried the same perl script with the same ACCESS database on a
MySQL database version 3.22.32 with no problems at all. So there MUST be
something wrong with version 3.23.33, don't you think?????
But, o.k., I will try to give you a bit more information about the error
message.
Cheers,
Tobias.
-----Ursprüngliche Nachricht-----
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im
Auftrag von Gerald L. Clark
Gesendet: Donnerstag, 8. März 2001 18:40
An: Tobias Wolff
Cc: Mysql
Betreff: Re: Duplicate Entry in Key 1
Tobias Wolff wrote:
>
> Hello,
> I have searched the mailing list for this topic, but didn't find a match
vor
> my problem.
>
> I am working on Linux Mandrake with MySQL 3.23.33 installed from the RPMs
> for Mandrake. I am trying to convert a ACCESS database to MySQL using a
perl
> script. The script makes connections to the ACCESS database via ODBC and
to
> the MySQL database. The script works find in converting several tables. On
> one table it fails with saying "duplicate entry in key 1" with "key 1"
being
> the primary key. Two funny things:
>
> 1. There isn't a duplicate entry for this key. Checked this over and over
> again.
> 2. It is not the same key. Each time I run the script it gives me a
> different key. Of course, I do drop the table first.
>
> Can someone help me??
> Thanks,
> Tobias.
>
Without a listing of the table structures, import files, and query
results
to prove your assertion, I would be inclined to believe MySQL.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
