Ordering a mysql table

[.:HyPeX:.]

Hello, how can i order a table by a column?

I can already retrive the value while selecting with "ORDER BY", but that wont change the table rows.

How can i actually change the table rows?

Greetz

HyPeX

[Gallardo9944]

Something like this should do it:

ALTER TABLE tops ORDER BY time ASC; 

(Change to DESC to switch sorting)

[.:HyPeX:.]

Something like this should do it:

ALTER TABLE tops ORDER BY time ASC; 

(Change to DESC to switch sorting)

That didnt worked...

http://www.w3schools.com/sql/trysql.asp ... t_distinct

[novo]

As specified here, an "ALTER TABLE ORDER BY" statement exists in the syntaxes accepted by MySQL so w3schools syntax checker might be slightly outdated.

So, as Gallardo stated above, you should do it as follows: (reference)

  
ALTER TABLE tablename ORDER BY columnname; 
ALTER TABLE tablename ORDER BY column1 ASC, column2 DESC; 
  

Though, at the beginning, the sort will begin to drift after additional INSERTs and DELETEs. Rows that will sorted will remain in their order, but new rows will be placed at the end.

And well, in case this causes any grand dilemma to you, you could simply sort the rows when fetching the table's results. (table.sort)

[Gallardo9944]

table.sort is much slower than mysql sorting. Doing that in your queries won't affect performance, tested with 3000 rows with 40 columns.

[.:HyPeX:.]

Actually, i like the simplicity of mysql sorting over table.sort, rather than by its performance.

I'll do a live test later.

Thanks guys.