[ciapug] Mysql

[Jeff Davis]

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
>