[ciapug] Mysql

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


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

-- 

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