Sounds to me like your indexes got corrupted. You can try fixing them with
the table fixer thing. But since you have such small data, just drop them
all, and recreate them.
At 01:09 AM 1/14/2001 -0800, David Young wrote:
>Ok, here's the scoop. After 3 days of research, noone has been able to
>give me an answer ...hopefully someone here can..yay! Anyway, I've got
>several tables all with 350+ records. The db itself has about 15 tables.
>When I run this query:
>
>"select field1 from table1;" it just sits there.
>
>When I run this query:
>
>"select field1 from table1 where field1 between '1' and '37';" it will
>display 37 records as requested.
>
>Now if I run the second query ..."select..between '1' and '38';" it just
>sits there....I've been running queries on this table for about 10 months.
>It's only a few days ago it decided not to respond to me, forcing me to
>take down a tool that was running off the table.
>
>Any ideas or suggestions as to a query I've run hundreds of times decided
>to just sit there?
>
>Any help would be great!
>
>Thanks!
>Dave Young
>Applications Engineer
><http://www.gluepoint.com>www.gluepoint.com
>"We make billing easy."
-------------------------------------
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"Always bear in mind that your own resolution to success is more important
than any other one thing." - Abraham Lincoln
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
