[ciapug] Mysql

[Carl Olsen]

I have no idea, but I would try inserting 10 records and see if it skips
any.  Then I would try inserting 590 records and see if it skips any.  If it
doesn't skip any, then it's some kind of a memory issue.  If it does skip
some, then at least you can look for minor differences in 10 records instead
of 1281.

Carl

-----Original Message-----
From: ciapug-bounces at cialug.org [mailto:ciapug-bounces at cialug.org] On Behalf
Of Dave J. Hala Jr.
Sent: Friday, January 06, 2006 9:41 AM
To: PHP List
Subject: Re: [ciapug] Mysql

No errors... isn't that wierd?  I even went so far and to dump the db
and reload it...


On Fri, 2006-01-06 at 09:23, Jeff Davis wrote:
> This happens without any errors displayed or in the log?
> 
> 
> 
> Dave J. Hala Jr. wrote:
> > I'm running  mysql 3.23.58.  I've run into an issue inserting records
> > into a table. The query criterion tells me there are 1281 records. When
> > I do the insert mysql only only inserts 591 records.
> > 
> > Here's the insert query:
> > 
> > INSERT INTO notify_temp SELECT * FROM lhpl_side WHERE SNP='0';
> > 
> > Anyone got any ideas as to why it skips/throws out 690 records?
> > 
> > 
> > 
> > :) Dave
> > 
> _______________________________________________
> ciapug mailing list
> ciapug at cialug.org
> http://cialug.org/mailman/listinfo/ciapug
-- 

Open Source Information Systems, Inc. (OSIS)
Dave J. Hala Jr., President <dave at osis.us>
641.485.1606

_______________________________________________
ciapug mailing list
ciapug at cialug.org
http://cialug.org/mailman/listinfo/ciapug