[ciapug] Mysql

[Carl Olsen]

Those are definitely some things that should be checked.

Carl

-----Original Message-----
From: ciapug-bounces at cialug.org [mailto:ciapug-bounces at cialug.org] On Behalf
Of Jeff Davis
Sent: Friday, January 06, 2006 11:46 AM
To: ciapug at cialug.org
Subject: Re: [ciapug] Mysql

Just a guess but have you compared the table structure of both tables?
i.e. Fields set to unique, not null, other referential integrity issues?

Example:
If you're doing something like pulling NULL's out of
field 1 on table A and trying to put them into field 1
on table B, but field 1 on table B is a NOT NULL field.

(I would still expect an error if that was the problem though.)

-Jeff



Dave J. Hala Jr. wrote:
> I can't upgrade until Aug-Sept of 2007. Its a live well tested, mature
> working system. This server is also the replicating master for a number
> of other servers.
> 
> Why this issue hasn't shown up in the last 3 years is beyond me. At this
> point, doing that upgrade would be like buying a new car because I've
> got a flat tire.
> 
> However, in 07' I'll probably move to mysql 5.0 and php 5, so the plan
> is in the works.
> 
> With regard to your question regarding the select returning 1281, the
> answer is yes. I just don't undertand  why the query doesn't move all
> the records when using the wildcard.
> 
> 
> 
> :) Dave
> 
> 
> 
> On Fri, 2006-01-06 at 11:11, David Champion wrote:
>> 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
>> So you mean if you say "SELECT count(*) FROM lhpl_side WHERE SNP='0'" it 
>> returns 1281?
>>
>> You might want to look into upgrading your mysql version. 3.23.58 was 
>> released on 9/11/2003. That's ancient.
>>
>> Going up to 4.1.x, or even 5.x would get you some nice performance 
>> improvments, as well as several nice features, like sub selects...
>>
>> -dc
>>
>> _______________________________________________
>> ciapug mailing list
>> ciapug at cialug.org
>> http://cialug.org/mailman/listinfo/ciapug
_______________________________________________
ciapug mailing list
ciapug at cialug.org
http://cialug.org/mailman/listinfo/ciapug