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)
Hi Christoph, I would suggest you read up about indexes and how they would assist you in your requirements. Without knowing the exact structure of your tables, it is difficult to judge but it sounds like an index (or indexes), correctly structured, would provide what you need. A good read would be