[Newbie] table order question

[MarkusWolters]

Hi,

is there any possibility to add data to a table in alphabetical (lets say of coloumn 1) order?

regards Markus

 

[ceco]

you can add it whatever you like, when you retrieve it you can order it! simple SQL rules

SELECT * FROM your_table ORDER BY your_order_field;

the other way is to create VIEW, which will do basicly the same

CREATE VIEW your_view AS SELECT * FROM your_table ORDER BY your_order_field;

and now
SELECT * FROM your_view;