How to switch/rotate records?

[random1]

Hi All,

 

Is there a way in MYSQL to switch or rotate records based on an index or primary key?

 

i.e.

 

PK|  Name|  Description|

-----------------------------

1      test1    desc1

2      test2    desc2

 

updates to...

 

PK|  Name|  Description|

-----------------------------

1      test2    desc2

2      test1    desc1

 

Ultimately I am looking to sort the data itself in the database with an update sequence so I have the ability to sort by Name A-Z.

[random1]

So far I have:

 

UPDATE table1 SET table1_ID = table1_ID ORDER BY table1_name DESC;

 

But not working

[Mchl]

Why would you do it? You shouldn't.

[Hooker]

You can only set the order the result set, ie.

SELECT * FROM table1 ORDER BY table1.name DESC;

[fenway]

You can only set the order the result set

Strictly speaking, you can use ALTER TABLE to order rows, but that's usually meant for very expensive operations or on read-only tables.