Re: newbie: how to sort a database without extracting the data

2005-05-04 Thread Alec . Cawley
PROTECTED]> 04/05/2005 00:38 To mysql@lists.mysql.com, [EMAIL PROTECTED] cc Subject Re: newbie: how to sort a database without extracting the data 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

Re: newbie: how to sort a database without extracting the data

2005-05-03 Thread Christoph Lehmann
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

RE: newbie: how to sort a database without extracting the data

2005-05-03 Thread Logan, David (SST - Adelaide)
:[EMAIL PROTECTED] Sent: Wednesday, 4 May 2005 8:57 AM To: mysql@lists.mysql.com Subject: newbie: how to sort a database without extracting the data Hi I am really new to mysql. I need my database to be sorted according to one field. But since the database with 1200 records is huge, I don&#

newbie: how to sort a database without extracting the data

2005-05-03 Thread Christoph Lehmann
Hi I am really new to mysql. I need my database to be sorted according to one field. But since the database with 1200 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 databa