I was building an administrative console and decided to start with creating a table of Affiliate Networks.

So I added CJ, LS, SAS and Performics in that order, then I used MySQL GUI tools and ran this query:

SELECT * FROM affiliate_network a;

The query shows results in alphabetical order, instead of the order in which the items were inserted.

So instead of seeing the results as CJ, LS, SAS and Performics I see

CJ, LS, Performics and SAS

I find this very strange, because as far as I can remember Oracle wouldn't order records on its own , it would only order them if there was an ORDER BY clause.

This ordering also affects the way records appear on the UI Front End, it's definitely nice to have the results ordered , but I find it a little strange.