Is the CREATE TABLE you show the result of SHOW CREATE TABLE or your own
create statement? If the latter, please show the output of SHOW CREATE.
Does SELECT succeed if you remove the INSERT part of the statement?
You might want to consider adding an index on transactionlogid, this
could bring
Suresh <[EMAIL PROTECTED]> wrote:
> I am porting from 4.0.0-alpha-nt to 4.0.1-alpha-nt. In which i have a
> table with two primary key, my older mysql server insert all the records
> except the duplicate fields(Primary Key). Whereas in the new mysql
> server it exits whenever it sees a duplicate
Suresh wrote:
Hi,
Yes ofcourse it is a primary key with two fields. The insert exists whenever it
has a duplicate entry, it doesn't continue with further records. Is there any
scope to resolve it.
Thanks
Suresh
Eldo Skaria wrote:
insert ignore
--
MySQL General Mailing List
For list archives: h
Hi,
Yes ofcourse it is a primary key with two fields. The insert exists whenever it
has a duplicate entry, it doesn't continue with further records. Is there any
scope to resolve it.
Thanks
Suresh
Eldo Skaria wrote:
> Hi,
>
> Suresh may be expressing that he has a primary key with two fields.
>
Hi,
Suresh may be expressing that he has a primary key with two fields.
Eldo.
On Tue, 21 Sep 2004 19:32:17 -0400, Rhino <[EMAIL PROTECTED]> wrote:
>
> - Original Message -
> From: "Suresh" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, September 21, 2004 6:43 PM
> Subje
- Original Message -
From: "Suresh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 21, 2004 6:43 PM
Subject: Duplicate Entries
> Hello All,
>
> I am porting from 4.0.0-alpha-nt to 4.0.1-alpha-nt. In which i have a
> table with two primary key, my older mysql server
Sorry, but justs a quick remark on the top:
Have you looked at small and KAPITAL letters?
--
Franz Alt
[EMAIL PROTECTED]
> at work I run mysql 3.23.45. on a windows2000 machine with apache 1.3.23
> and php4.06. at home it's Linux SuSe *.0, mysql 4.03 apache 1.3.26 and
> php4.2.3. the problem i
rom: "Nick Wilson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 4:57 PM
Subject: Re: duplicate entries mystery
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> * and then Nick Wilson declared
> > I'm having some weir
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Nick Wilson declared
> I'm having some weirdness when inserting from the php api, I do not get
> the same results if I use the mysql server directly. Here is the code:
Please disregard. It appears to be some bizzare Apache/http thing,
