按列排序MySQL数据库

Question

I wish to sort a MySQL database by column. I have a small Database and would like to sort a particular column from low to high; then high to low. It should save the data after it has been sorted.

I would like to do this at the push of a button (hyperlink?) on my website setup that shows the records of the MySQL in a simple html table.

I found some code, (below)

ALTER TABLE tablename ORDER BY columnname ASC;.

Although am unsure how to actually implement this code. Any help in how do implement this code would be greatly apperciated.

Answer 1

create index

and

use ORDER BY clause in your query,

CREATE INDEX tablename01 ON tablename (columnname);