[ciapug] Mysql

Dave J. Hala Jr. dave at 58ghz.net
Fri Jan 6 09:40:30 CST 2006


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



More information about the ciapug mailing list