simple sql select does not return the correct number of rows

[JoLiang]

I have 2668 rows in my table.

select count(distinct ID) from mytable;

gives the following results: 2668

However, when I use:

select ID from uniprot;

I only get 1000 rows returned, what could be the problem?

I use windows xp 1 GB ram, and mysql 4.0.18

Any help is appreciated.

 

[swampBoogie]

May be a configuration issue with the frontend you are using.

 

[rzs0502]

Try:
select ID from uniprot limit 2000;

Your query tool (possible MySQL Control Center) limits your results to 1000 (to prevent hangs on huge result sets).
If you are using MySQL CC you can change this in the Options.


"If you always do what you've always done, you will always be where you've always been."

 

[TonyGroves]

Are you by any chance using MySQL Control Centre?

If so, open the program, select the server, click the Edit button, click the MySQL Options tab, and set the "Automatically limit SELECT queries to" field to 0, meaning no limit.

-----
ALTER world DROP injustice, ADD peace;