thanks Damian but I don't understand this: My field according to which I want the database to be sorted IS an unique number.
eg I have
1 ab 33 1 cd 21 1 ac 32 2 aa 22 2 cd 25 3 kw 03 3 ie 02 2 ei 05 2 wk 00
I need it in the form:
1 ab 33 1 cd 21 1 ac 32 2 aa 22 2 cd 25 2 ei 05 2 wk 00 3 kw 03 3 ie 02
what do you mean by adding an index thanks for your help
cheers christoph
Damian McMenamin wrote:
add an index on the field. would be quickerthan any exporting importing. --- Christoph Lehmann <[EMAIL PROTECTED]> wrote:Hi
I am really new to mysql. I need my database to be sorted according
to one field. But since the database with 12000000 records is huge, I
don't want to do it using SELECT.
What I need is just the stored database being sorted on hard-disk. Is
there any way doing this like creating a new database and importing
the old one but being sorted?
many thanks for your kind help
cheers christoph
(p.s. I need this for later chunk-wise data-fetch with one chunk
being homogenous in regard to one (the sorted) field)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Yours Sincerely,
Damian McMenamin
Analyst Programmer
Melbourne Australia
Cell: (61)040-0064107
Email: [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
