rommelalix
Programmer
hi gurus,
hi i already did the MYISAMCHK on my corrupted tables,, i dont get error 1030 anymore, but im still wondering why is it whenever i request a query,, it does'nt give me the complete results..
this is the situation:
select acctname from <<tablename>> where acctname like 'A%' limit 40000;
---- this query gives me 40000 records
select heading from <<tablename>> where acctname like 'A%' limit 40000;
---- this query gives me only 1664 records, i counted the "should be" output with <<select count..>> command and it gives me more than 1664.
-- why is this happening? i have an index on field <<acctname>>, does it affect this? maybe my index is also corrupted.. please advice
thanx very much
hi i already did the MYISAMCHK on my corrupted tables,, i dont get error 1030 anymore, but im still wondering why is it whenever i request a query,, it does'nt give me the complete results..
this is the situation:
select acctname from <<tablename>> where acctname like 'A%' limit 40000;
---- this query gives me 40000 records
select heading from <<tablename>> where acctname like 'A%' limit 40000;
---- this query gives me only 1664 records, i counted the "should be" output with <<select count..>> command and it gives me more than 1664.
-- why is this happening? i have an index on field <<acctname>>, does it affect this? maybe my index is also corrupted.. please advice
thanx very much