[ciapug] Mysql

[Carl Olsen]

I'd still recommend trying to import a couple rows or as many as it takes to
generate a problem.  It would be easier to compare a couple rows than it
would 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 11:03 AM
To: carl-olsen at mchsi.com; PHP List
Subject: RE: [ciapug] Mysql

I don't if its a memory issue or not. I'd think that would generate and
error message. However when I this:

INSERT INTO source (id,afn,lhp,fnm,lnm,uvc,svc,snp,sns)
SELECT id,afn,lhp,fnm,lnm,uvc,svc,snp,sns FROM target where snp='0'  
It works, and I get the right number of records.  Very strange.

On Fri, 2006-01-06 at 09:49, Carl Olsen wrote:
> 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