I would like to use Toad for MySQL but i need help with the following thing:
When i open the data view of a table i want to sort it by on the column names.
I have a table with 10000 record an want to view it with 300 record per page. Lets asume i have one column with the number from 10000 till 20000.
NOW: when i click on the column name the table gets sortet within the 300 records on the page. So when i want to sort DESCENDING i see 10299, 10298, 10297 ...
WHAT I NEED: the sorting should by done directly by the database so i get the 300 first records of all 10000 sorted by the column i clicked. So when i want to sort DESCENDING i see 20000, 19999, 19998 ...
It would also be great when null values would be somehow displayed as null value and not an empty field.
Which settings do i have to change to set this up?
I already tried to find something in the manual but i didn't find anything.
Re: Direct Sorting with Limit
Feb 28, 2011 11:17 AM
in response to: Shodantos