I have table with 3 columns: "FirstCol", "SecondCol" and "ThirdCol". I need to sort table by "FirstCol".
I know that I can sort table using
SELECT * FROM `TableName` ORDER BY `FirstCol` DESC
But this way only works when I output data.
I need to sort the rows in the table itself. That is, the rows will be stored sorted in the database file.